I noticed that problem when I adjusted the query to run against production data. I moved the @today condition to the subquery and it seems to be working OK now.

...

Looks great - Thank you VERY much for the help!

WayneS:

I'm using SQL Server 2008, so the OUTER APPLY works fine. The output you posted is exactly what I'm looking for, however I can't add new tables (like Employee2). Is...

durai nagarajan (2/14/2011)

when the report processing time is short it wont show the report generating wheel.

kindly give us the time for report lauching in report server and in .net page...

Thanks Jack for your help / patience. Unfortunately (and I hate sounding too negative) the following doesn't seem to work for me:

Select

...

If I do that, the application will blow in front of the user when the first NULL value comes up.. the code is not ready to handle that for now....

Got it. Now, if I understand you correctly, this will give me all the statements that involve this table. Is it possible to determine which statement is inserting the null...

Thanks for your reply. I've never done this so I'm doing some research now on how to filter by object_id and put the trace results in a table - so...