| Author |
 Topic  |
|
|
Srinika
Flowing Fount of Yak Knowledge
Sri Lanka
1378 Posts |
 Posted - 03/27/2012 : 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
India
47040 Posts |
Posted - 03/27/2012 : 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 MVP
http://visakhm.blogspot.com/
|
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Srinika
Flowing Fount of Yak Knowledge
Sri Lanka
1378 Posts |
Posted - 03/27/2012 : 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
India
47040 Posts |
Posted - 03/27/2012 : 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 MVP
http://visakhm.blogspot.com/
|
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 03/27/2012 : 22:43:16
|
output the result into 2 separate temp tables for old SP and new SP and compare it using query
KH
Time is always against us
|
|
|
| |
Topic |
|
Stored Procedure Testing
