Stored Procedure to create a cross-tab query

Question

User1312450783 posted

Hello,

Can anyone point me in the right direction on how to write a stored procedure to create a cross tab query within ASP.net? I can create the output I need exactly the way I want in MS Access - but can't seem to get it displayed in a grid-view within ASP.net.  Here is the sql I'm using that works in Access:

********************************************

TRANSFORM Sum(EmployeeHoursTotals.Hours) AS SumOfHours
SELECT EmployeeHoursTotals.Employee, EmployeeHoursTotals.LastName, EmployeeHoursTotals.FirstName, Sum(EmployeeHoursTotals.Hours) AS [Total Of Hours]
FROM EmployeeHoursTotals
GROUP BY EmployeeHoursTotals.Employee, EmployeeHoursTotals.LastName, EmployeeHoursTotals.FirstName
PIVOT EmployeeHoursTotals.Building;

****************************************

Thanks! Any help would be great appreciated!