USE T26S001

UPDATE T27S001.DBO.OPENING_GREY_PURCHASE SET ItemName = '' WHERE ItemName IS NULL
UPDATE T27S001.DBO.OPENING_GREY_PURCHASE SET ItemName = T1.F3 FROM (SELECT GREY_PURCHASE.WeaverCode AS F1, GREY_PURCHASE.BillNo AS F2, GREY_PURCHASE_ITEM_DETAIL.ItemName AS F3 FROM GREY_PURCHASE INNER JOIN GREY_PURCHASE_ITEM_DETAIL ON GREY_PURCHASE.SrNo = GREY_PURCHASE_ITEM_DETAIL.SrNo WHERE GREY_PURCHASE_ITEM_DETAIL.ItemSrNo = 1) AS T1 WHERE T27S001.DBO.OPENING_GREY_PURCHASE.WeaverCode = T1.F1 AND T27S001.DBO.OPENING_GREY_PURCHASE.BillNo = T1.F2+'#'


USE T25S001

UPDATE T27S001.DBO.OPENING_GREY_PURCHASE SET ItemName = '' WHERE ItemName IS NULL
UPDATE T27S001.DBO.OPENING_GREY_PURCHASE SET ItemName = T1.F3 FROM (SELECT GREY_PURCHASE.WeaverCode AS F1, GREY_PURCHASE.BillNo AS F2, GREY_PURCHASE_ITEM_DETAIL.ItemName AS F3 FROM GREY_PURCHASE INNER JOIN GREY_PURCHASE_ITEM_DETAIL ON GREY_PURCHASE.SrNo = GREY_PURCHASE_ITEM_DETAIL.SrNo WHERE GREY_PURCHASE_ITEM_DETAIL.ItemSrNo = 1) AS T1 WHERE T27S001.DBO.OPENING_GREY_PURCHASE.WeaverCode = T1.F1 AND T27S001.DBO.OPENING_GREY_PURCHASE.BillNo = T1.F2+'##'


USE T24S001

UPDATE T27S001.DBO.OPENING_GREY_PURCHASE SET ItemName = '' WHERE ItemName IS NULL
UPDATE T27S001.DBO.OPENING_GREY_PURCHASE SET ItemName = T1.F3 FROM (SELECT GREY_PURCHASE.WeaverCode AS F1, GREY_PURCHASE.BillNo AS F2, GREY_PURCHASE_ITEM_DETAIL.ItemName AS F3 FROM GREY_PURCHASE INNER JOIN GREY_PURCHASE_ITEM_DETAIL ON GREY_PURCHASE.SrNo = GREY_PURCHASE_ITEM_DETAIL.SrNo WHERE GREY_PURCHASE_ITEM_DETAIL.ItemSrNo = 1) AS T1 WHERE T27S001.DBO.OPENING_GREY_PURCHASE.WeaverCode = T1.F1 AND T27S001.DBO.OPENING_GREY_PURCHASE.BillNo = T1.F2+'###'