...
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
UPDATE D
SET D.IsDeleted=1
FROM WM.ASNDetails D
INNER JOIN WM.ASN H ON H.ASN_ID=D.ASN_ID
WHERE H.IsDeleted=0 AND D.IsDeleted=0 AND H.StateID=5;
UPDATE WM.ASN SET IsDeleted=1 WHERE IsDeleted=0 AND StateID=5;
|
...
Page History
Overview
Content Tools