Hi Luis,

This is great!!

Would you kindly tell me how do I use my table in the following query?

My table already has data and the table is as follows:

CREATE TABLE TempSSProf_CustData

(PERSON [nvarchar](15) NOT NULL,

DATA [nvarchar](200) NULL,

FIELD [nvarchar](30) NOT NULL)

Thank you Luis.

WITH SampleData (PERSON, [DATA], [FIELD]) AS -- I will replace SampleData with this table TempSSProf_CustData

(

/**what goes in here?**/

SELECT 1234,'04/02/2014','Date'

UNION ALL SELECT 1234,'123','Department'

UNION ALL SELECT 1234,'80.0','Rate'

)

SELECT PERSON,

MAX( CASE WHEN FIELD = 'Date' THEN DATA END) AS [Date],

MAX( CASE WHEN FIELD = 'Department' THEN DATA END) AS Department,

MAX( CASE WHEN FIELD = 'Rate' THEN DATA END) AS Rate

FROM SampleData -- I will replace SampleData with this table TempSSProf_CustData

GROUP BY PERSON;