Information générale
Forum:
Microsoft SQL Server
Titre:
Group by a varying # of days
Versions des environnements
SQL Server:
SQL Server 2008
Hello,
I have a standard SQL table holding customer orders. The table has a customerID, an order date, and an order quantity. I would like to create a query that would give me a count of orders and a total amount of orders for 'n' number of days within a date range. For example, I want to see a weekly count (# of days would be 7) for orders for each customer starting Jan 1, 2011 up to today.
I could say that maybe my variable time frames would be weekly, monthly, quarterly or yearly.
Any ideas on how to do this?
TIA
Bob
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement