Link to home
Start Free TrialLog in
Avatar of lulu50
lulu50Flag for United States of America

asked on

Total count of records selected

Hi,

I need to find out the total count of records selected.

select IssueID
from SelectedDepartment 
where DepartmentImpactedID in (2,51) 
and (CreatedDate >= '01/17/2014' 
and CreatedDate <= '07/16/2014') 
Group by IssueID

the output that I have right now is this: 

IssueID
644
645
650
652
753

The output that I am looking for is this: 

TotalCountOfRecordFound
5

So, how am I going to change my query to get me this output?

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lulu50

ASKER

Great!!!!

Thank you sdstuber
Avatar of lulu50

ASKER

Thank you