lấy data hóa đơn thanh toán bị lệch.txt
| 1 |
DECLARE @p_REQ_PAY_ID varchar(15) = (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT where REQ_PAY_CODE = '052025/001237') |
|---|---|
| 2 |
DECLARE @quantity int, @quantity1 int, @quantity2 int, @quantity3 int |
| 3 |
SET @quantity = ( SELECT count(*) |
| 4 |
FROM TR_REQ_PAY_INVOICE A |
| 5 |
WHERE (@p_REQ_PAY_ID = A.REQ_PAY_ID) AND A.TYPE_FUNC='HC') |
| 6 |
|
| 7 |
SET @quantity1 = ( SELECT count(*) |
| 8 |
FROM TR_REQ_PAY_INVOICE A |
| 9 |
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID |
| 10 |
WHERE 1=1 |
| 11 |
AND (@p_REQ_PAY_ID = A.REQ_PAY_ID) AND A.TYPE_FUNC='HC') |
| 12 |
|
| 13 |
SET @quantity2 = ( SELECT count(*) |
| 14 |
FROM TR_REQ_PAY_INVOICE A |
| 15 |
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID |
| 16 |
LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID |
| 17 |
WHERE 1=1 |
| 18 |
AND (@p_REQ_PAY_ID = A.REQ_PAY_ID) AND A.TYPE_FUNC='HC') |
| 19 |
|
| 20 |
|
| 21 |
SET @quantity3 = ( SELECT count(*) |
| 22 |
FROM TR_REQ_PAY_INVOICE A |
| 23 |
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID |
| 24 |
LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID |
| 25 |
LEFT JOIN TL_USER US ON B.MAKER_ID = US.TLNANME |
| 26 |
WHERE 1=1 |
| 27 |
AND (@p_REQ_PAY_ID = A.REQ_PAY_ID) AND A.TYPE_FUNC='HC') |
| 28 |
|
| 29 |
SELECT @quantity, @quantity1, @quantity2, @quantity3 |