I reviewed the Cross Tab and Pivot queries you suggested. I went with Cross Tab, but i am getting this result now.

ID, Office, Office1, Office2

1,Testing, Testing, NULL

2,Hello World, NULL,...

Is anyone actually running the code on 2012? If so can the code be shared so others out there can take advantage of this report on 2012

Thank You very much for your response.

I have solved that issue, but unfortunately using the ExcepCodeDetailName wouldn't be an option as there are over 200 of them and not every...

Kevin,

Thank you for the reply and help on this matter. Now for the funny part, the db is on 2008R2 and i posted in the wrong section. Sorry...

Let me add the code and the resultset so it will be easier and quicker to possibly help me out.

DECLARE @Testing AS TABLE (

AgentID INT,

ExcepCodeDetailName VARCHAR(10),

Detail_Start_Time DATETIME,

Detail_End_Time DATETIME

)

INSERT INTO @Testing...

Tim,

Executing the Stored Proc on 2008R2 gives this error....

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

Msg 102, Level 15, State 1,...