Below is the code which I used

SELECT

Pvt.KeyColumn,

Pvt.[1] Column1,

Pvt.[2] Column2,

Pvt.[3] Column3,

Pvt.[4]...

Hi Guys,

i got it working..............

Just rank the records. and then use Pivot operator in SQL 2005 to move the column values into single row.

Cheeers...........