CR 10 against SQL Server
I have a listing of the number of calls and the days they were made.
Day 1
1
2
3
4
5
Day 2
1
2
3
total days = 2
I have it group to give me the total calls per day and the total calls for the month. What i need to do is get the total number of days these calls were made on per person. I cannot use the distinct count, cause these are datetime fields.
Billy Ballard
For in the past, Lies the future.
I have a listing of the number of calls and the days they were made.
Day 1
1
2
3
4
5
Day 2
1
2
3
total days = 2
I have it group to give me the total calls per day and the total calls for the month. What i need to do is get the total number of days these calls were made on per person. I cannot use the distinct count, cause these are datetime fields.
Billy Ballard
For in the past, Lies the future.