I have a report which is based on an a stored procedure. This returns data based upon parameters supplied at runtime from a form. Results are usually returned within a few seconds.
There are certain values which when passed as parameters cause the stored procedure to take longer (4 mins). When this happens many of the rows are not returned. If I run the same stored procedure in Query Analyser it returns the correct number of rows (and takes same amount of time).
I appreciate that I need to look at my indexes to speed up the stored procedure. I would however still be keen to find out why rows are being lost.
There are certain values which when passed as parameters cause the stored procedure to take longer (4 mins). When this happens many of the rows are not returned. If I run the same stored procedure in Query Analyser it returns the correct number of rows (and takes same amount of time).
I appreciate that I need to look at my indexes to speed up the stored procedure. I would however still be keen to find out why rows are being lost.