Skip to main content


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

Comments

Post a Comment

Popular posts from this blog

Alter Table Column MsSql

Following is the important script for database server as the table "tbl_Log" as already created. For Adding Default Value in Table ALTER TABLE YourTable ADD CONSTRAINT DF_SomeName DEFAULT N'1' FOR YourColumn ; For Increasing the Column Size ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (50) NOT NULL; For Add/Creating New Column ALTER TABLE PRESENTED_VOUCHER add  descrip  nvarchar(200); For Change/Modify Existing Column  ALTER TABLE PRESENTED_VOUCHER alter column  descrip  nvarchar(200);
9 comments
Read more

VUE JS INSTALLATION

PROBLEM / ERROR npm WARN invalid config registry="" npm WARN invalid config Must be a full url with 'http://' npm WARN invalid config registry="" npm WARN invalid config Must be a full url with 'http://' SOLUTION / FIX I resolve this problem by running the following command on dos / command line npm config rm proxy npm config rm https-proxy  
1 comment
Read more