How to take a SP like a table

Hi

Any one knows how to take a SP(stored procedure) like a table, obviously the SP throws a search

or other way that can help me is if when I execute a varchar, but i

want to manipulate like a table, the varchar has a simple search like

select * from user

Thanks for your help

I can't work out what you're asking for here. Perhaps you want a View, which is code like a SP, but can be referenced as if it was a table ?

|||

You can use OPENQUERY for that:

http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/580d0f2c5079e063

HTH, Jens Suessmeyer.