22,301
社区成员




--1.
CREATE TABLE #TmpBillCheckList(FExplanation VARCHAR(MAX) DEFAULT(' '))
--2
INSERT INTO #TmpBillCheckList(FExplanation)
SELECT a.FExplanation
FROM t_rp_newReceiveBill a
INNER JOIN t_rp_arbillofsh c
ON a.FBillID = c.FBillID
JOIN t_rp_contact b
ON a.FBillID = b.FBillID
LEFT JOIN t_currency cur
ON a.FCurrencyID = cur.FCurrencyID
LEFT JOIN t_item i
ON a.FCustomer = i.FItemID
LEFT JOIN t_item ii
ON a.FDepartment = ii.FItemID
LEFT JOIN t_item iii
ON a.FEmployee = iii.FItemID
LEFT JOIN t_user s
ON a.FPreParer = s.FUserID
LEFT JOIN t_user t
ON a.FChecker = t.FUserID
LEFT JOIN t_settle x1
ON a.FSettle = x1.FItemID
LEFT JOIN t_rp_systemenum x2
ON a.FBillType = x2.FItemID
LEFT JOIN (
SELECT v1.FVoucherID,
v1.FNumber,
v2.Fname FName
FROM t_voucher v1
INNER JOIN t_vouchergroup v2
ON v1.FGroupid = v2.fgroupid
)v
ON b.FVoucherID = v.FVoucherID
WHERE 1 = 1
AND (
c.FID_SRC = 0
OR c.FClassID_SRC NOT IN (1000000, 1000002, 1000003, 1000004,
1000005, 1000014, 1000021, 1000022,
1000500, 1000501, 1000502, 1000503,
1000520, 1000521, 1007140, 1000016,
1000018, 1000511, 1000510)
)
AND a.FRp = 1
AND a.FPre IN (0, -1)
AND b.FType NOT IN (8, 9)
AND a.FCheckStatus <> 1
AND a.FItemClassID IN (1)
AND (b.FStatus & 1) = 1
AND (b.FStatus & 16) = 0
AND i.FNumber >= '01.BTC125'
AND i.FNumber <= '01.BTC125'
AND a.FCurrencyID = 1000
--3
SELECT len(FExplanation) AS theLen,FExplanation
FROM #TmpBillCheckList WHERE len(FExplanation)>255
ORDER BY len(FExplanation) DESC
--4
DROP TABLE #TmpBillCheckList