June 7, 2013 at 3:49 pm
Is there a way to "stack" columns in a table on a report?
My example would be getting some info out of [msdb].[dbo].[sysjobhistory]. I'd like to see the name of the job (and _id), the step_id, step_name, run_date, run_time and run_duration on one "row", with the message on the next (see attached).
I can't create different datasets as there would be multiple rows per job_id and I'd like them to "meld".
select
j.name
,j.job_id
,jh.step_id
,jh.step_name
,jh.run_date
,jh.run_time
,jh.run_duration
,jh.message
from
sysjobs j inner join sysjobhistory jh on j.job_id = jh.job_id
where
jh.job_id = '<some job id>'
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 11, 2013 at 2:37 pm
Hi
Maybe you can create 2 new detail lines
Then join the text box on the first detail line to put the static text "Message"
and then do the same with the second detail line and put the field Message on it
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply