Skip to main content

Posts

Showing posts from 2015

Updates of Software on Haram Traders

Complete Database of All Departments as UAE - Dubai - 2015
This is development work done in UAE - Dubai.
Changes & Updates in HRM Software Module
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