Pivot Rows to Columns in SQL Server

Pivot row values to columns by using this pattern in SQL Server

SELECT @strValues = COALESCE(@strValues+',', '') + FirstName
FROM
( SELECT DISTINCT FirstName FROM [AdventureWorksLT2008R2].[SalesLT].[Customer]) X
ORDER BY FirstName

SELECT [Result]= @strValues

ref: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53885