存储过程版本1alter PROCEDURE QSP_GET_BACK_SIGN site varchar20 AS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDdeclare b3 intdeclare b4 intSELECT b3=b3b4=b4 FROM b_arg SELECT 0 as ischecked

ALTER PROCEDURE QSP_GET_BACK_SIGN @site varchar(20) AS BEGIN 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.address,
    a.state,
    a.shipper,
    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,
    shippertel,
    shippermb,
    a.middlesite,
    outbillno,
    vipno,
    addr,
    weight,
    volumn,
    fapiaono,
    shippercompany,
    consigneecompany,
    acchuokuankou,
    acctotal,
    acctax,
    a.tyddate
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

END G