How to perform a select on a Stored Proc

StrataFrame Forum

How to perform a select on a Stored Proc

http://forum.strataframe.net/Topic6881.aspx

By Paul Chase - 2/16/2007

I am trying to do something like this

select index_name as [name], index_description as [Description], Index_keys as [key]

FROM

(exec sp_helpindex 'Employee')

which doesnt work Smile any ideas on how to perform a select on a stored procedure?

By Greg McGuffey - 2/16/2007

Try aliasing the sproc expression:

From (exec sp_somesproc) as S

By Paul Chase - 2/19/2007

I tried that before and does not work. I dont think is is possible... Anyways I figured screw it and just write the query to get the data I need dont have time to mess with it for one 3 column query