|
|
Posted by Kart on 09/08/06 09:31
Hi,
I didnt understand your question completely. But if you mean you want
to use one SP's result in another SP, then there are a few options...
1. Put the value into a temporary table and then access these values in
the second SP.
2. You can have a global cursor
But if you are looking at using one SP's output in a query, then I dont
think this is possible. You can look at creating a table valued
functon.
Regards,
Karthik
Lucky wrote:
> hi guys!
>
> it's very very simple question for you mighty sql DBAs. but very hard
> for a developer like me who is very very new to MS SQL.
>
> anyways the problem is i want to use one SPs out to in the SELect
> statement. here is an example :
>
> select * from sp_tables tablename like 'syscolumns'
>
> please note that this is just an example. i'm using different SP but i
> want to use in the same way.
>
> if anybody has anything to say. please write to me. i would be glade to
> read your replies
>
> Thanks,
> Lucky
Navigation:
[Reply to this message]
|