how to update data in multiple tables in single query in sql server - fabulouscode

Tuesday, March 5, 2019

how to update data in multiple tables in single query in sql server


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