Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
 Posted - 2012-03-27 : 11:40:32
|
| I need to modify some stored procedures, for that to be more efficient and concise.I need to know, is there any way to check the output of old SP & new SP, for different parameters, to see the differences?I can generate the parameters & the SQL to be executed in a script, but not sure of a way to test the output.If no straight forward method, let me know if there is any tool.Srinika |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-27 : 12:17:47
|
| why not populate the resultset onto excel template in two different sheets one old and other new and compare between them using excel formula/macro?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2012-03-27 : 22:39:50
|
| To Visakh,It is not just 1 results set. It may be about 200,000 ~ 300,000 records ( about 5000 records for each parameter set)It is practically impossible huge load of data :(To X002548,The SP returns a results set in the end. That is the output. I need to check whether I get the same output for all parameters, after the change as well.Srinika |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-27 : 22:42:37
|
quote:
Originally posted by Srinika
To Visakh,It is not just 1 results set. It may be about 200,000 ~ 300,000 records ( about 5000 records for each parameter set)It is practically impossible huge load of data :(To X002548,The SP returns a results set in the end. That is the output. I need to check whether I get the same output for all parameters, after the change as well.Srinika
why cant you load it to seperate sheets in excel and do the comparison?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-27 : 22:43:16
|
output the result into 2 separate temp tables for old SP and new SP and compare it using query
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Stored Procedure Testing