Our Training Programs

All contents are copyright of their authors.

How to stored procedure data run select statement

How to stored procedure data run select statement

Nirmal KumarC

9yAsked Feb 28, 2017, 7:04 AM935

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.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Nitin Sontakke9y ago
Accepted 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 Sontakke9y ago
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.
Nirmal KumarC9y ago
I know but am want to only select Statement wise get data So i am given below format Join qury also used

SELECT sp.Column1,sp.Column2,sp.Column3, t.column1,t.column2
FROM sp_name (any Argumnets) sp INNER JOIN table2 t ON t.no = sp.no

Thanks and Regards
Nirmal
Nitin Sontakke9y ago
I think you mean insert not select.

So it should be

insert into #temptable
execute OB_Course_Seats 'MC', 0, -1