by SysAnalys » Wed, 05 Mar 2003 07:48:26
Is there any way to perform an SQL SELECT statement from the returned
resultset of a stored procedure?
Example:
Select colA, colD, colH, colJ
from ( Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )
order by colA
This doesn't work but you should get the point.
R
by Bob Barro » Wed, 05 Mar 2003 07:56:08
>Is there any way to perform an SQL SELECT statement from the returned
>resultset of a stored procedure?
>Example:
>Select colA, colD, colH, colJ
>from ( Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )
>order by colA
>This doesn't work but you should get the point.
HTH,
Bob Barrows
Please reply to the newsgroup. My reply-to address is my "spam trap" and I don't check it very often.
by hngo0 » Wed, 05 Mar 2003 07:57:56
querying the group.Quote:>-----Original Message-----
>Can't seem to locate anything on this topic so I am
Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )Quote:>Is there any way to perform an SQL SELECT statement from
the returned
>resultset of a stored procedure?
>Example:
>Select colA, colD, colH, colJ
>from (
Quote:>order by colA
>This doesn't work but you should get the point.
>R
>.
by Bob Barro » Wed, 05 Mar 2003 07:58:56
>Is there any way to perform an SQL SELECT statement from the returned
>resultset of a stored procedure?
>Example:
>Select colA, colD, colH, colJ
>from ( Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )
>order by colA
>This doesn't work but you should get the point.
Here's an example that was provided by Tom Moreau a few posts ago:
create view MyView
as
SELECT
*
FROM
OPENROWSET
(
'SQLOLEDB'
, 'SERVER=(local);Trusted_Connection=yes'
, 'SET FMTONLY OFF EXEC sp_who2'
)
HTH,
Bob Barrows
Please reply to the newsgroup. My reply-to address is my "spam trap" and I don't check it very often.
by Bob Barro » Wed, 05 Mar 2003 08:14:03
>Is there any way to perform an SQL SELECT statement from the returned
>resultset of a stored procedure?
>Example:
>Select colA, colD, colH, colJ
>from ( Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )
>order by colA
>This doesn't work but you should get the point.
HTH,
Bob Barrows
Please reply to the newsgroup. My reply-to address is my "spam trap" and I don't check it very often.
by SysAnalys » Wed, 05 Mar 2003 16:12:51
R
> >Can't seem to locate anything on this topic so I am querying the group.
> >Is there any way to perform an SQL SELECT statement from the returned
> >resultset of a stored procedure?
> >Example:
> >Select colA, colD, colH, colJ
> >from ( Exec 'SomeExistingStoredProcedure ''SomeParameter'' ' )
> >order by colA
> >This doesn't work but you should get the point.
> And more from Erland:
> http://www.algonet.se/~sommar/share_data.html
> HTH,
> Bob Barrows
> Please reply to the newsgroup. My reply-to address is my "spam trap" and I
1. Calling a Stored Procedure from within a Stored Procedure
Is there a way to call a stored procedure from within a stored procedure?
Thanks,
April
3. Calling a stored procedure from within a stored procedure
4. SQL Anywhere stored proc: RESUME??
5. Calling a stored procedure within a stored procedure.
7. Retrieving result from a stored procedure called within another stored procedure
9. Calling Oracle Stored Procedure from within SQL Server Stored Procedure
10. Calling a stored procedure on another server from within a stored procedure
11. Calling Stored Procedure that calls Stored Procedure in ASP
12. Calling a Java Stored Procedure from another Java Stored Stored Procedure
13. How do you call a stored procedure from within another stored procedure?