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 |
|
agnesko
Starting Member
1 Post |
 Posted - 2003-09-19 : 13:12:47
|
| I have a stored procedure that return a data set. I want to select some fields from the stored procedure result data set under some condition. Is is possible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-19 : 13:18:41
|
| You could do this using a user-defined function. You could also do this by putting the result set into a temporary table:INSERT INTO #TempEXEC dbo.usp_SomeProc @SomeVariableTara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-19 : 14:13:41
|
| Can you p[ost the sproc so we can see what you're talking about?Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
|
|
|
select data from storeproc result