Converting an Access pivot query to SQL 2005

[csharpnewbie]

Hi, I am new to table pivot and would like to know how to go about converting the following query in Access to SQL Server 2005:

TRANSFORM First(tbl_Proj_Budget.BUGDET_LINE_BURDENED_COST) AS FirstOfBUGDET_LINE_BURDENED_COST
SELECT tbl_Proj_Budget.PROJ_ID, First(tbl_Proj_Budget.BUGDET_LINE_BURDENED_COST) AS [Total Of BUGDET_LINE_BURDENED_COST]
FROM tbl_Proj_Budget
GROUP BY tbl_Proj_Budget.PROJ_ID PIVOT tbl_Proj_Budget.RESOURCE_LIST_ALIAS;

For instance, what does the 1st line mean?

TRANSFORM First(tbl_Proj_Budget.BUGDET_LINE_BURDENED_COST) AS FirstOfBUGDET_LINE_BURDENED_COST

Thanks

[NoellaG]

Hi,

I think you can use the PIVOT statement (introduced in SQL 2005).

SELECT [pivot column1] as C1
[pivot col2] as C2
......
FROM [data providing query]
PIVOT [PIVOT statement] as MyPivotTable

grNG