1 down vote favorite
I want to count the number of 'Present' each person's Present Dates in a Month as I mention Above .please help How can I count row wise?
(Off the top of my head...)
You could do something like:
An alternative would be to use the UNPIVOT statement
Something like that.
Note: all code untested. Suggestions only. I'm not on a machine with SQL Server to test this stuff...