Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
Query to calculate Quantity on Hand
Imran Bashir
8 years ago
295
Reply
i want to calculate the quantity when the product is sale that come in stock table with product_id and quantity add in stock_out
and when the purchase then quantity add in Stock_in can u plz tell me how to make the query to know the quantity
SELECT TOP 1000 [id]
,[product_id]
,[stock_date]
,[stock_in]
,[stock_out]
,[vocher_type]
,[vocher_id]
FROM [OnlineTradingFinal].[dbo].[Stock]
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
column which have the same id
How to manage credit debit amount in ms sql in table