StrataFrame Forum » .NET Forums » General .NET Discussion » How to perform a select on a Stored Proc

How to perform a select on a Stored Proc

Paul Chase — Mon, 19 Feb 2007 08:09:09 GMT

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 :) any ideas on how to perform a select on a stored procedure?

RE: How to perform a select on a Stored Proc

Paul Chase — Mon, 19 Feb 2007 08:09:09 GMT

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

RE: How to perform a select on a Stored Proc

Greg McGuffey — Fri, 16 Feb 2007 10:47:10 GMT

Try aliasing the sproc expression:

From (exec sp_somesproc) as S