Access Result Set from storede procedure w/in a stored procedure

Hi All
I have a stored procedure, sp_GetNameDetail, which return a one row, multiple columns result set.
Yet I have another storede procedure which would call sp_GetNameDetail, and would like to access this result set. Is there a way I can do this?
Thanks,Two choices

Use multiple output variables
or
Use a table variable.

access link table

Hi,All
I created a view in our SQL server database, which in the view I can delete
a record according to the cascade delete relationship. Now, we would like to
do it in Access database, so I created an ODBC link to our access database,
from access database I tried to delete the record as well, I got the error
message:
ODBC-delete on a linked table 'dbo_vwSpecialConcerts' failed.
[Microsofe][ODBC SQL Server Drive][SQL Server]View or function
'dbo.vwSpecialConcerts' is not updatable because the modification affects
multiple base tables. (#4405).
Any ideas to solve the problem ?
It's hard to say without knowing what's in the view, but I suspect
you'll need to perform the update against the base table(s) or create
a view with no joins.
--Mary
On Mon, 14 Feb 2005 16:45:06 -0800, "Symphony"
<Symphony@.discussions.microsoft.com> wrote:

>Hi,All
>I created a view in our SQL server database, which in the view I can delete
>a record according to the cascade delete relationship. Now, we would like to
>do it in Access database, so I created an ODBC link to our access database,
>from access database I tried to delete the record as well, I got the error
>message:
>ODBC-delete on a linked table 'dbo_vwSpecialConcerts' failed.
>[Microsofe][ODBC SQL Server Drive][SQL Server]View or function
>'dbo.vwSpecialConcerts' is not updatable because the modification affects
>multiple base tables. (#4405).
>Any ideas to solve the problem ?

access link table

Hi,All
I created a view in our SQL server database, which in the view I can delete
a record according to the cascade delete relationship. Now, we would like to
do it in Access database, so I created an ODBC link to our access database,
from access database I tried to delete the record as well, I got the error
message:
ODBC-delete on a linked table 'dbo_vwSpecialConcerts' failed.
[Microsofe][ODBC SQL Server Drive][SQL Server]View or function
'dbo.vwSpecialConcerts' is not updatable because the modification affects
multiple base tables. (#4405).
Any ideas to solve the problem ?It's hard to say without knowing what's in the view, but I suspect
you'll need to perform the update against the base table(s) or create
a view with no joins.
--Mary
On Mon, 14 Feb 2005 16:45:06 -0800, "Symphony"
<Symphony@.discussions.microsoft.com> wrote:

>Hi,All
>I created a view in our SQL server database, which in the view I can delete
>a record according to the cascade delete relationship. Now, we would like t
o
>do it in Access database, so I created an ODBC link to our access database,
>from access database I tried to delete the record as well, I got the error
>message:
>ODBC-delete on a linked table 'dbo_vwSpecialConcerts' failed.
>[Microsofe][ODBC SQL Server Drive][SQL Server]View or function
>'dbo.vwSpecialConcerts' is not updatable because the modification affects
>multiple base tables. (#4405).
>Any ideas to solve the problem ?