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 |
|
ashraff87
Starting Member
17 Posts |
 Posted - 2008-08-04 : 07:01:56
|
| Hi,I want to compare two results sets from two different stored procedures using an EXCEPT statment, however i cannot just do this for a rough example..EXEC sprocnameEXCEPTEXEC sprocname do i need to be selecting those exec statments? how can i use the results of a sproc in another statment?Thanks , Ash |
|
|
pootle_flump
1064 Posts |
Posted - 2008-08-04 : 07:53:26
|
| Depending on your code, you might consider recoding them (e.g. into table valued functions).Anyway, you can insert the output of a sproc into a table and work with the result sets in that way. There is another fudge to work with sproc outputs as a set but it is pretty ugly. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-04 : 08:38:48
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/26/select-columns-from-exec-procedure-name-is-this-possible.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Using sproc results?