problem with count query

getnitha

Hi,

I need a help.I want to get the count of a row

id fstday secday 3day 4day 5day

aaa P A P A A bbb A P P A P

In the above result i pasted two rows of data from my table.I want to get the count of each employee having values as 'p' .FOR EG

i want the result set as for userid aaa ------------------2 (Its having 2 P's)

and for userid bbb------------------3 (Its having 3 P's)

plse help me to find this

Regards
Nitha

debasisdas

Question moved to SQL Server Forum.

iburyak

Try this :

Expand|Select|Wrap|Line Numbers

 select id, 

case when fstday = 'P' then 1 else 0 end +

case when secday = 'P' then 1 else 0 end +

case when  3day = 'P' then 1 else 0 end +

case when 4day = 'P' then 1 else 0 end +

case when 5day = 'P' then 1 else 0 end Result

from table_name

problem with count query

re: problem with count query

re: problem with count query

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about