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?

 

P

 

Try aliasing the sproc expression:



From (exec sp_somesproc) as S

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