x

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 '12 at 07:51 AM in Default

Haren gravatar image

Haren
51 8 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 '12 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x264
x74

asked: Jan 21 '12 at 07:51 AM

Seen: 1266 times

Last Updated: Jan 22 '12 at 02:02 AM