Software and Web Development

STOCK CLOSING SQL SCRIPT select * from [LMC2014-15].dbo.stock_rep ORDER BY 1 select * from [LMC2015-16].dbo.item ORDER BY 1 UPDATE  [LMC2015-16].dbo.item SET [LMC2015-16].dbo.item.OPEN_QTY=0  UPDATE A  SET A.open_qty = B.Qty_in_hand  FROM [LMC2015-16].dbo.item A, [LMC2014-15].dbo.stock_rep B  WHERE A.item_CODE = B.item_code UPDATE  [LMC2015-16].dbo.item SET [LMC2015-16].dbo.item.AMOUNT=[LMC2015-16].dbo.item.OPEN_QTY * [LMC2015-16].dbo.item.COST_RATE