You must Sign In to post a response.

31 Jul 2018 15:49

Joined:	25/04/2007
Level:	Gold
Points:	408

Points:	5

How to get stock balance of every end of month

Date Customer InvoiceNo StockBalance
11/29/2017 A IN000414 5000
11/30/2017 B IN000415 4000
12/27/2017 A IN000416 3500
12/30/2017 B IN000417 2000
I want to get Stockbalance of every end of month, I need the output as

11/30/2017 B IN000415 4000
12/30/2017 B IN000417 2000
how could i get this could anybody guide to me?

#769677

02 Aug 2018 17:57

Joined:	28/09/2005
Level:	Gold
Points:	637

Points:	2

can you try with below query.

Select * from stock Where [Date] In(Select Max(Date) from stock group by Month(Date))

Thanks!
B.Ramana Reddy

Submit New Thread

Return to Return to Discussion Forum

How to get stock balance of every end of month

About dotnetspider.com

Quick Links

General

Services