... coloured pictures and charts that management wants to see ...

I get that A LOT is the part of my job I don't really like but they sign my...

I looks like your problems far outperform my guesses

yep , I will go the sp route and maybe computed columns if at all possible!

if there are no locks for a process id then that row won't be present in the result set!

WOW, That's why validation and QA are NEEDED

you may do something from a trigger at the table level Like:

DBCC INPUTBUFFER(@@SPID) to determine what was run but only the first 255 char will be returned

is that what you...

Yep, Like every great thing, is based on the hard effort of a lot of people

Alter Table rr

ADD CONSTRAINT DF_rr_s  DEFAULT 'N' FOR s

This type of scenario is also very used in Datawarehousing, so keep that in mind

If you run profiler you can corroborate that

Frank's link is one of the most complete descriptions I have seen for this kind of opperations

Is this what you are after?

DELETE FROM tblMMStudentTestScores

FROM  #MMTestsToDelete DL

Where    (tblMMStudentTestScores.TestShortName = 'HMRM' OR 

 tblMMStudentTestScores.TestShortName = 'HMLM') 

 AND

 (tblMMStudentTestScores.Permnum  = DL.MTPermnum AND

 tblMMStudentTestScores.TestShortName = DL.MTTestShortName)

If you need ALL the Fields then  here it goes :

SELECT T.*

FROM

 #TempResults T

 Join

 ( Select DISTINCT Q.FileId, Q.Filename

   From  #TempResults) Q

 On Q.FileId =T.FileId and Q.Filename...

if all you want is FileID and File name as the output then

Select DISTINCT Q.FileId, Q.Filename

From

( Your Query) Q

order by Q.FileID, Q.FileName

SWEET !!!