SQL Server存储过程：获取待签收回单信息

ALTER PROCEDURE QSP_GET_BACK_SIGN @site varchar(20) AS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @b3 int DECLARE @b4 int SELECT @b3 = b3, @b4 = b4 FROM b_arg

SELECT 0 AS ischecked, a.unit, a.billno, a.billdate, a.bsite, a.esite, a.state, a.shipper, a.tyddate, a.consignee, a.product, a.qty, backqty, s1 = CASE WHEN ISNULL(fetchdate, '') <> '' THEN 1 ELSE 0 END, s2 = CASE WHEN ISNULL(modifyremark, '') <> '' THEN 1 ELSE 0 END, s3 = CASE WHEN ISNULL(isbad, 0) > 0 THEN 1 ELSE 0 END, s4 = CASE WHEN ISNULL(outinoneflag, '') = '' THEN 0 ELSE 1 END, acctype, accnow, accarrived, accback, accmonth, accdaishou, acczz, accsend, webid, createby, outcygs, outdate, acctype, shippertel, shippermb, a.middlesite, outbillno, vipno, addr, weight, volumn, fapiaono, shippercompany, consigneecompany, acchuokuankou, acctotal, acctax FROM B_TYD AS a LEFT JOIN b_tyd_trace_tpl AS b ON (a.unit = b.unit) WHERE ( a.esite = @site OR a.middlesite = @site OR ( a.bsite = @site AND @b4 = 1 ) OR ( a.bsite = @site AND ((a.state = 10 AND tosite = 0) OR okprocess = '司机直送') ) ) AND signdate IS NULL AND ISNULL(backrecipient, '') = '' AND ISNULL(a.backqty, '') <> '' AND a.state <> 100 AND a.state <> 11