t sql to compute opening & closing stock

Hi everyone,

I am looking for stored procedure, to calculate the opening stock as on date & total receipt, total issue & closing balance. I have 4 tables 1 Product_Master- Having product details, Opening_stock table having field Opening_stock for each product, Receipt_detail table with quantity & Txn_date for receipt & issue_detail table having txn_date & quantity. How to make store procedure to first calculate opening of particular date & then total receipt, total issue for the specific period ( between 2 dates )

Please help
more ▼

asked Jan 21, 2012 at 07:51 AM in Default

Haren gravatar image

51 10 10 11

For homework questions, please show the work you've done that's not working. I'll be happy to help out, but I'm not going to do the work for you unless I'm going to get the grade instead of you.
Jan 22, 2012 at 03:52 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

0 answers: sort oldest
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 21, 2012 at 07:51 AM

Seen: 1500 times

Last Updated: Jan 22, 2012 at 02:02 AM