UPDATE
tblFinishingMachineProcessSetupNew
SET IsStarted='1', IsCompleted='1'
FROM dbo.tblDyeingWIPHandover AS DHO INNER JOIN
dbo.tblFinishingMachineProcessSetupNew AS PSN ON DHO.HandoverID = PSN.HandoverID INNER JOIN
dbo.tbl_RS_RecipeHead AS RH ON DHO.BatchHeadID = RH.MachineBatchPlanningHeadID
WHERE (RH.prod_Date BETWEEN CONVERT(DATETIME, '2015-12-01 00:00:00', 102)
AND CONVERT(DATETIME, '2016-01-05 00:00:00', 102)) AND (PSN.BaseMachine = 1800)
AND DHO.BatchName='27615' AND PSN.IsStarted='0' AND PSN.IsCompleted='0'
No comments:
Post a Comment
I am Safiqul Islam Tuhin