How Can I Get Individual Results In Sql Server Ce

I'm using SQL Server CE as my database with asp.net. I'm querying the database as follows. SELECT DispatcherName, ActivityType, COUNT(ActivityType) AS Total FROM Activity WHERE (Be

Solution 1:

I know this is a years old, but since there is no answer to it yet, here is an article that could help answer how: http://pratchev.blogspot.com/2007/04/pivoting-data-in-sql-server.html

The official way would be using pivot but since in CE its not available, using alternatives for pivot as describe in the article would be the best way to achieve it.

Hope this helps for anyone looking into similar issues.