The @differencetable isn't recognised as declared, how would I resolve this?
Any assistance is welcome.
Thank you
SQLMicrosoft SQL Server
Last Comment
Dustin Saunders
8/22/2022 - Mon
Ryan Chong
quick try...
update @DifferenceTable set InventoryQty = tt.Qty from (select sum(InventTrans.QTY)*-1 as Qty , InventTransOrigin.DATAAREAID , REFERENCEID , InventTrans.INVOICEID , InventTrans.ITEMID from InventTransOrigin left join InventTrans on InventTrans.INVENTTRANSORIGIN = InventTransOrigin.RECID and InventTrans.DATAAREAID = InventTransOrigin.DATAAREAID and InventTrans.ITEMID = InventTransOrigin.ITEMID where REFERENCECATEGORY = 0 group by InventTransOrigin.DATAAREAID , REFERENCEID , InventTrans.INVOICEID , InventTrans.ITEMID ) tt inner join @DifferenceTable on @DifferenceTable.DataAreaId = tt.DATAAREAID and @DifferenceTable.SalesId = tt.REFERENCEID and tt.INVOICEID = @DifferenceTable.InvoiceId and tt.ITEMID = @DifferenceTable.ItemId
Open in new window
SQL Server UPDATE JOIN
https://www.sqlservertutorial.net/sql-server-basics/sql-server-update-join/