Viewing 6 posts - 1 through 6 (of 6 total)
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,...
March 2, 2015 at 3:39 pm
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
July 23, 2014 at 8:25 am
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...
August 13, 2013 at 12:00 pm
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...
August 13, 2013 at 11:32 am
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...
August 13, 2013 at 11:03 am
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,...
November 27, 2012 at 2:03 pm
Viewing 6 posts - 1 through 6 (of 6 total)