Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Symbol_of_king Kurra Bewarse Username: Symbol_of_king Post Number: 2161 Registered: 12-2005 Posted From: 75.93.50.185 Rating: N/A Votes: 0 Posted on Friday, February 28, 2014 - 3:27 pm:    select count(items),sum(case when closeddate is null then 0 else 1 end) from items where xxxxx