5.0 UPDATE PUR 527 SO LE.txt
| 1 |
DECLARE @DATE DATETIME, @REQ_ID VARCHAR(15) |
|---|---|
| 2 |
SET @DATE ='2021-04-16 12:00:00 AM' |
| 3 |
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000457') |
| 4 |
UPDATE TR_REQUEST_DOC_DT SET OFFERING_VALUE =85168.6 WHERE PRICE =85168.6 AND REQ_DOC_ID =@REQ_ID |
| 5 |
UPDATE TR_REQUEST_DOC_DT SET OFFERING_VALUE = 98213.5 WHERE PRICE =98213.5 AND REQ_DOC_ID =@REQ_ID |