How do get SQL query for from and todate wise month list for a product wise

Question

1.00/5 (2 votes)

See more:

Dear Techie, this is my requirement, thanks for your support and effort
TaskName StartDate FinishDate Amount
Product-1 01/03/2018 15/02/2020 75000
Product-2 01/03/2018 15/02/2023 50000
Product-3 01/03/2018 29/03/2019 25000
Product-4 01/03/2019 25/03/2020 10000
Product-5 01/01/2020 15/02/2023 15000

My Output like this
Perpoduct and StartDate,FinishDate Month wise amount will split
Like
Product-1 March-18 6250.00
April-18 4166.67
May-18 2083.33
June-18 833.33
July-18 1250.00
August-18 0.00
September-18 0.00
upto-Last Finishdate 0.00
Product-2 Same above

What I have tried:

My code is not much

Dear Techie, this is my requirement, thanks for your support and effort
TaskName	StartDate	FinishDate	Amount
Product-1	01/03/2018	15/02/2020	75000
Product-2	01/03/2018	15/02/2023	50000
Product-3	01/03/2018	29/03/2019	25000
Product-4	01/03/2019	25/03/2020	10000
Product-5	01/01/2020	15/02/2023	15000
			
My Output like this			
Perpoduct and StartDate,FinishDate Month wise amount will split			
Like			
Product-1	March-18	6250.00	
	April-18	4166.67	
	May-18	2083.33	
	June-18	833.33	
	July-18	1250.00	
	August-18	0.00	
	September-18	0.00	
	upto-Last Finishdate	0.00	
Product-2	Same above

Posted 15-Dec-19 22:24pm

Member 2000765

Updated 15-Dec-19 23:36pm

Add a Solution

Comments

Maciej Los 16-Dec-19 4:36am

What's your problem?
Note: we can't read in your mind or direct from your screen. So, you have to describe your issue and provide the examples to explain what you want to achieve.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2019-12-15T23:01:00

Solution 1

Try using GROUP BY.
Something like:

SQL

SELECT ProductName, MIN(EnterDate), MAX(EnterDate), SUM(Amount)
FROM MyTable
GROUP BY ProductName

Posted 15-Dec-19 23:01pm

OriginalGriff

Member 2000765 · Answer 2 · 2019-12-15T23:36:00

Solution 4

Thanks, but my requirement is StartDate, FinishDate breakups
like Monthwise, Amount

Thanks

Posted 15-Dec-19 23:36pm

Member 2000765

Comments

Maciej Los 16-Dec-19 5:55am

This is not an answer. Please, delete it to avoid down-voting. To post comment, use "Have a question or comment" widget under the solution you want to post a comment.

How do get SQL query for from and todate wise month list for a product wise

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0

How do get SQL query for from and todate wise month list for a product wise

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us