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 |
|
taunt
Posting Yak Master
128 Posts |
 Posted - 2011-06-08 : 17:53:53
|
| Hello, stupid question where does SQL 2005 store the results of a stored procedure? I've select result to text, grid and file and get nothing. It stores a xml of the result, but where? Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
taunt
Posting Yak Master
128 Posts |
Posted - 2011-06-08 : 18:24:38
|
| Well it looks like this:USE database;GOIF NOT EXISTS(SELECT field FROM table WHERE (zzz = 'zzz') or(aaa = 'aaa') or(ccc = 'ccc') or(ddd = 'ddd') or(eee = 'eee') or)BEGINSELECT 'not found'ENDI Need it to show me what results it can't find from our database. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
taunt
Posting Yak Master
128 Posts |
Posted - 2011-06-09 : 12:11:57
|
| I need it to display the result it can't find in our database. For instance sku aa1, aa2, aa3. I need it to tell me that aa3 isn't in the database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Stored Procedures result?