itemid availableqty 100 0 101 0 102 0 103 0 104 0 105 0
itemid availabelqty branch 101 20 1 101 30 2 101 30 3 102 90 1 102 80 2 102 20 3 102 30 4 103 40 1 103 30 4 103 50 2 103 70 3
itemid availableqty 100 0 101 80 102 220 103 190 104 0 105 0
update tblitemmaster set availableqty=(select sum(availableqty) from stockdetails where itemid =110) where ItemID =102
UPDATE t1 SET t1.avaliblequality = t2.avaliblequality FROM itemmaster AS t1 INNER JOIN ( SELECT itemid, SUM(avaliblequality) AS avaliblequality FROM stockdetails GROUP BY itemid ) AS t2 ON t1.itemid = t2.itemid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)