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
原文地址: https://www.cveoy.top/t/topic/op6p 著作权归作者所有。请勿转载和采集!