Page History

...

Code Block

language	sql
title	اکت
linenumbers	true

--حذف  درخواست های خروج لاین های الارو و شون در حالت ثبت اولیه و به تاریخ ۲۰ شهریور - با ديتيل

UPDATE D
SET D.IsDeleted=1
FROM WM.IssueOrderDetails D
     INNER JOIN WM.IssueOrder H ON H.IssueOrder_ID=D.IssueOrder_ID
	 INNER JOIN Product.BarcodeMain B ON B.BarcodeMain_ID = D.BarcodeMain_ID
	 INNER JOIN Product.ProductMain P ON P.ProductMain_ID = B.ProductMain_ID
	 INNER JOIN Product.CodingBrand Br ON Br.CodingBrand_ID = P.CodingBrand_ID
WHERE H.IsDeleted=0 AND D.IsDeleted=0 AND H.StateID=3 AND H.IODate='2022-09-11 00:00:00.000'
AND P.CodingBrand_ID IN (14007,140010)

UPDATE H
SET H.IsDeleted=1
FROM WM.IssueOrderDetails D
     INNER JOIN WM.IssueOrder H ON H.IssueOrder_ID=D.IssueOrder_ID
	 INNER JOIN Product.BarcodeMain B ON B.BarcodeMain_ID = D.BarcodeMain_ID
	 INNER JOIN Product.ProductMain P ON P.ProductMain_ID = B.ProductMain_ID
	 INNER JOIN Product.CodingBrand Br ON Br.CodingBrand_ID = P.CodingBrand_ID
WHERE H.IsDeleted=0 AND  H.StateID=3 AND H.IODate='2022-09-11 00:00:00.000'
AND P.CodingBrand_ID IN (14007,140010)

Code Block

language	sql
title	اکت
linenumbers	true

--حذف درخواست خروج های ثبت اولیه از ابتدا تا انتهای تاریخ 26 مهر ماه  - با دیتیل
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-10-18 23:59:59.000'
  
UPDATE WM.IssueOrder SET IsDeleted=1 WHERE IsDeleted=0 AND StateID=3 AND IODate<='2022-10-18 23:59:59.000'

Code Block

language	sql
title	اکت
linenumbers	true

--حذف درخواست هاي خروج و ورود ثبت اولیه تا انتهاي 13/8/1401  - با دیتیل
/*-------------IssueOrder------------*/
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-11-05 00:00:00.000';
  
UPDATE WM.IssueOrder SET IsDeleted=1 WHERE IsDeleted=0 AND StateID=3 AND IODate<'2022-11-05 00:00:00.000';

/*-------------ASN------------*/
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 AND H.ASNDate<'2022-11-05 00:00:00.000';
  
UPDATE WM.ASN SET IsDeleted=1 WHERE IsDeleted=0 AND StateID=5 AND ASNDate<'2022-11-05 00:00:00.000';

Page tree

Versions Compared

Old Version 4

New Version Current

Key