how to get total sale with month wise, week wise, day wise

Question

1.00/5 (1 vote)

See more:

pls some one tell that

how to get total sale with month wise, week wise, day wise in sql server.

Pls some one tell......

Posted 18-Dec-13 7:18am

chander rani

Add a Solution

1 solution

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 · 2013-12-18T08:10:00

Solution 1

Try something like:

SQL

Get count of this month, and today:
SELECT SUM(Sales) AS TotalSales,
       SUM(CASE WHEN DATEDIFF( m, SaleDate, GETDATE() ) = 0 THEN Sales ELSE 0 END) AS SalesThisMonth,
       SUM(CASE WHEN DATEDIFF( d, SaleDate, GETDATE() ) = 0 THEN Sales ELSE 0 END) AS SalesToday
FROM MyTable

Posted 18-Dec-13 8:10am

OriginalGriff

Comments

Maciej Los 18-Dec-13 16:36pm

5.

how to get total sale with month wise, week wise, day wise

1 solution

Solution 1

Add your solution here

Preview 0

how to get total sale with month wise, week wise, day wise

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us