Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Required Query

    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

Viewing post 1 (of 1 total)