Select 1

[mayu03]

I have the following code in my sp where I am passing the param:
select count(*) as Voided from Table1 where groupNumber=@GroupID and status='V'
select count(*) as Active from Table1 where groupNumber=@GroupID and status='A'

I wanted to display this way when the sp exec:
Voided x
Active y

Is it possible to do this?

 

[JayKusch]

select 'Voided ' + CONVERT(Char,count(*)) from Table1 where groupNumber=@GroupID and status='V'
select 'Active ' + CONVERT(Char,count(*)) from Table1 where groupNumber=@GroupID and status='A'



Thanks

J. Kusch

 

[checkai]

AVOIDS USING SUBQUERIES

SELECT CASE WHEN STATUS = 'V' THEN 'VOIDED' ELSE 'ACTIVE' END AS TYPE,
       COUNT(*)
FROM TABLE1
WHERE GROUPNUMBER = @GROUPID
GROUP
BY CASE WHEN STATUS = 'V' THEN 'VOIDED' ELSE 'ACTIVE' END