Thanks for the reply, Steve. Have you figured out why only some SP's caused problems? What was different about the ones that caused problems versus SPs that were ok? There must be something common to the problem-causing SPs ... something the rest of us might want to be aware of.
~~Bonnie
>Hi Bonnie,
>
>We only upgraded one of our clients last week to SQL 2005 and the performance problem was more noticable to end user when running reports, but from what we can see it was happening when filling datasets in general, whether normal or CR (but not all datasets and not all CR's).
>
>To fix the problem SP's, we declared variables in the SP for the same datatypes as the parameters, then passed the data from the parameter to the variable and used the variables in the SELECT statements then the performance was back to what we expected.
>
>Thanks
>Steve