SELECT MAX(CASE WHEN Rn=1 THEN File END) AS Row1,
MAX(CASE WHEN Rn=2 THEN File END) AS Row2,
MAX(CASE WHEN Rn=3 THEN File END) AS Row3
FROM
(SELECT ROW_NUMBER() OVER (PARTITION BY (ID-1)/3 ORDER BY ID) AS Rn,(ID-1)/3 AS Grp,*
FROM Table
)t
GROUP BY Grp
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Distribute each 3 rows in one column
Posted - 07/05/2012 : 05:26:05
