How to stored procedure data run select statement

Question

How to stored procedure data run select statement query get data stored in temporary table?

What I have tried:

select * from #Temptable

(exec OB_Course_Seats 'MC',0,-1)

how to get storeprocedure data store in Teporary(#Temptable) table above query wise get possible result.

Nitin Sontakke · Answer

No! No!! Something like that is not possible. You are using stored procedure like a table returning function which is not possible. If you want to do that please look into table value function (TVF) in SQL Server. You can use that one as you have mentioned in your query.

Nitin Sontakke · Answer

Otherwise what you can do is put entire data returned by the stored procedure in a # table and then use that # table as per your requirement. Simple.

Nitin Sontakke · Answer

I think you mean insert not select. So it should be insert into #temptable execute OB_Course_Seats 'MC' 0 -1

Nirmal KumarC · Answer

I know but am want to only select Statement wise get data So i am given below format Join qury also used SELECT sp.Column1sp.Column2sp.Column3 t.column1t.column2 FROM sp_name (any Argumnets) sp INNER JOIN table2 t ON t.no = sp.no Thanks and Regards Nirmal