Tool for comparing result of 2 stored procs

Hi,

We are in the process of tuning the performance of our stored procs in
SQL 2000 and are looking for a tool that would help us in comparing
the result sets of an old SP and a modified SP. The tool should take
as input the names of the 2 SPs, a set of parameter values and invoke
them. Internally it should compare the result sets returned and log/
display the difference in result sets if any.
We do not want to compare response time, but want to compare result
sets just to be sure that the modifications have not changed the
functionality of the SP.
The tool should also be able to compare result sets of SPs that give
out multiple record sets.

Please let us know which tool we can use.

Thanks,
Yash

Re: Tool for comparing result of 2 stored procs

Yash, 07.11.2007 14:58:
> Hi,
>
> We are in the process of tuning the performance of our stored procs in
> SQL 2000 and are looking for a tool that would help us in comparing
> the result sets of an old SP and a modified SP. The tool should take
> as input the names of the 2 SPs, a set of parameter values and invoke
> them. Internally it should compare the result sets returned and log/
> display the difference in result sets if any.
> We do not want to compare response time, but want to compare result
> sets just to be sure that the modifications have not changed the
> functionality of the SP.
> The tool should also be able to compare result sets of SPs that give
> out multiple record sets.
>
> Please let us know which tool we can use.

Why not simply export the results in a text file and then compare the
text files?

Thomas