brammp (3) [Avatar] Offline
#1
Please try to fully qualify columns in examples to make them easier to follow:

E.g.
SELECT session_Id AS [Spid]
, ecid
, DB_NAME(sp.dbid) AS [Database]
, nt_username
, er.status
, wait_type
, SUBSTRING (qt.text, (er.statement_start_offset/2) + 1, #1
((CASE WHEN er.statement_end_offset = -1
THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
ELSE er.statement_end_offset
END - er.statement_start_offset)/2) + 1) AS [Individual Query]
, qt.text AS [Parent Query]
, program_name
, Hostname
, nt_domain
, start_time

Which view does [ecid], [nt_domain] come from, for instance...
ian.stirk (27) [Avatar] Offline
#2
Re: Please fully qualify all columns
Hi,

thanks for your message. I will endeavor to qualify the column names.

Thanks
Ian
rhandloff (3) [Avatar] Offline
#3
Re: Please fully qualify all columns
I agree. This would be very helpful!
ian.stirk (27) [Avatar] Offline
#4
Re: Please fully qualify all columns
Hi,

I am currently qualifying the columns as part of the proofreading process.

Thanks
Ian