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 |
|
jql
Starting Member
30 Posts |
 Posted - 2010-12-31 : 05:53:19
|
| Hii am trying to create a report that shows the open number of cases per day for a given period.the query works where the referral date is less than @date but the end date is greater than @date or is null.i have got the query to work where @date = 30-dec-2010 but am having trouble getting a day by day total for dates 27-dec-2010 to 30-dec-2010.i am guessing i need to add in a date for each day but have no idea how to achieve thisthe results i would like to see are as followsdate total27/12 4528/12 5229/12 4830/12 53any help would be appreciatedRegards |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-31 : 07:24:24
|
| add a group by clause on the date column.PBUH |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-12-31 : 09:53:08
|
| Can you post the code you are using?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
query help please