Posted by Lucky on 09/08/06 08:22

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

• Next in forum: Re: How to display the managers and the employees working under that Manager
• Prev in forum: Re: Creating a dynamic Global Temp Table within a stored procedure
• Thread view: how to use SP's output in the SELECT Statement

[Reply to this message]