Hi,

I haven't used PIVOT because this can be solved with a CASE statement.

DECLARE @table TABLE

(

[Key] VARCHAR(50),

Value VARCHAR(50)

)

INSERT INTO @table

SELECT 'firstname', 'surya'

UNION ALL SELECT 'firstname', 'rakhi'

UNION ALL SELECT 'firstname', 'venkat'

UNION ALL SELECT 'firstname', 'shankar'

UNION ALL SELECT 'firstname', 'dany'

SELECT

CASE WHEN = 'firstname' THEN Value END AS FirstName

FROM

@table

ORDER BY

CASE WHEN = 'firstname' THEN Value END

Hope that helps.

Thanks,

Simon