|
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
(comments are locked)
|
Be the first one to answer this question
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.