Does anyone know if its possible at all to execute a Select query directly against a stored procedure in SQL Server 2005 ?
Printable View
Does anyone know if its possible at all to execute a Select query directly against a stored procedure in SQL Server 2005 ?
you can use OPENROWSET pls. refer thread for sample
You can load sproc results into a temp table...
Create Table #Temp (col1 int, col2 xxx, col3 yyy...)
Insert into #Temp Exec SomeSproc
Ah, I kinda got it to work. The syntax checks out, it just has a problem identifying the provider or something. Shouldn't be an issue to figure out. Thank you both.
If you know the COLUMNS before hand do not use an OPENROWSET.