Viewing 6 posts - 1 through 6 (of 6 total)
michael_davis2 (2/8/2010)
That is something I stated it does (display the first query used). Eventually I'll build a section (probably using a CTE) to concatenate all of the queries together.
Thanx....
February 8, 2010 at 1:30 pm
There is also a problem when there are more than 1 datasets belonging to a report. This solution only prints out the value for the first occurance of <commandText>
February 8, 2010 at 1:17 pm
This does not appear to be quite right. We have stored procedures called from within the report stored procedure.
For example sp Rpt.Supplies is the stored proc called...
February 5, 2010 at 7:02 am
This is only for reports that run occasionally. most users select 1 to 3 clients, so it is not high on our list at this time to optimize this
August 20, 2007 at 5:51 am
i approach it a little differently. I use a function to split a parameter value into its different pieces
I also provide an All option with -1 being the value...
August 13, 2007 at 6:46 am
i need a new left leg
http://www.sql-server-performance.com/rvb_processing_event%20_logs.asp
December 28, 2006 at 5:27 am
Viewing 6 posts - 1 through 6 (of 6 total)