Viewing post 1 (of 1 total)
The following query also works in case you do not want to use 'case'.
select Interviewdate, PostId,
AcceptedCount=sum(charindex("Accepted",status)),
RejectedCount=sum(charindex("Rejected",status))
from #Candidate
group by Interviewdate, PostId
August 11, 2003 at 11:54 pm
#469494