ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/Pivot total row wise as category of floor/Pivot total row wise as category of floor