...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
--حذف درخواست خروج های ثبت اولیه با دیتیل
UPDATE D
SET D.IsDeleted=1
FROM WM.IssueOrderDetails D
INNER JOIN WM.IssueOrder H ON H.IssueOrder_ID=D.IssueOrder_ID
WHERE H.IsDeleted=0 AND D.IsDeleted=0 AND H.StateID=3;
UPDATE WM.IssueOrder SET IsDeleted=1 WHERE IsDeleted=0 AND StateID=3; |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
--حذف درخواست خروج ها و جداول وابسته
delete from wm.IssueOrderDetails
delete from WM.BasketDiff
delete from wm.BasketLog
delete from wm.BasketControlItemPDATemp
delete from wm.BasketControlItem
delete from WM.Basket
delete from wm.IssueOrder |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
--حذف درخواست خروج های ثبت اولیه هشتم شهریورماه - با دیتیل UPDATE D SET D.IsDeleted=1 FROM WM.IssueOrderDetails D INNER JOIN WM.IssueOrder H ON H.IssueOrder_ID=D.IssueOrder_ID WHERE H.IsDeleted=0 AND D.IsDeleted=0 AND H.StateID=3 AND H.IODate='2022-08-30 00:00:00.000'; UPDATE WM.IssueOrder SET IsDeleted=1 WHERE IsDeleted=0 AND StateID=3 AND IODate='2022-08-30 00:00:00.000'; |