Select count datediff in SQL Server

Asked Nov 21 '12 at 00:48

Active Nov 21 '12 at 05:59

Viewed 1,244 times

I'm having issues getting the desired results from my database. The join_service_date and dropped_service_date columns have dates. The rejects have an r in the column if it is rejected.

I want to be able to count the agents sales, rejects, dropped sales and how many of those sales have dropped our service within 0-30 days, 31-60 days or 61-90 days. I got the results I needed from doing several small queries, but I would like to learn or know how to gather the information in a just 1 or as little as possible queries.

Also how would I specify this for a specific month like march or april.

select agentid, 
       count(join_service_date), 
       count(dropped_service_date),
       count(rejects), 
       datediff(day, join_service_date, dropped_service_date)
from dbtable
group by agentid

edited Nov 21 '12 at 05:59

marc_s

732,580
175
1,330
1,459

asked Nov 21 '12 at 00:48

user1660858

Have you tried using GROUP BY or even any one of the conditionals (CASE/IF)? – RonaldBarzell Nov 21 '12 at 00:54
No I haven't because I didn't know how to use the case/if conditionals – user1660858 Nov 21 '12 at 15:48
I recommend googling them. Different dialects of SQL support different conditionals; the nice thing about them is you can include them within the parenthesis of your counts or other aggregates... – RonaldBarzell Nov 21 '12 at 15:50

Select count datediff in SQL Server

0 Answers0