lulu50
asked on
Total count of records selected
Hi,
I need to find out the total count of records selected.
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
ASKER
Thank you sdstuber