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 :

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