Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-28 : 17:28:14
|
Julian writes "I have a table of customer visits, something like:
PK_VisitID - varchar(10)
FK_CustomerID - varchar(10)
Date - datetime
What I need is a query that will count the number of visits per day, for the past 30 days. The tricky part (for me at least) is how to include days where no visits occur. If this doesn't make sense, I need something like:
Date: 1/1/01 | NumOfVisits: 5
Date: 2/1/01 | NumOfVisits: 6
Date: 3/1/01 | NumOfVisits: 0
Date: 4/1/01 | NumOfVisits: 2
Date: 5/1/01 | NumOfVisits: 0
etc
I can already easily produce the following result:
Date: 1/1/01 | NumOfVisits: 5
Date: 2/1/01 | NumOfVisits: 6
Date: 4/1/01 | NumOfVisits: 2
etc
Any ideas?
Regards
Julian" |
|
|
|
|
|
Aggregate date query