How to pass procedure return result set into a Temprary Table ?

Question

5.00/5 (1 vote)

See more:

Hi Friends,

I want to pass a result set of a procedure into temp table

How can i perform it???

Thanks in Advance

Shreeniwas

Posted 26-Feb-13 22:46pm

SriNivas IT

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Azziet · Answer 1 · 2013-02-26T22:49:00

Solution 1

check this link..

http://stackoverflow.com/questions/653714/how-to-select-into-temp-table-from-stored-procedure[^]

Posted 26-Feb-13 22:49pm

Azziet

Comments

CHill60 27-Feb-13 4:56am

My 5 and now I'm off to read up more about openrowset !

SriNivas IT 27-Feb-13 4:56am

But I can not use sp_configure proc to change setting can i not do that like

select * from (Exec SP_Name 'p1',p2,'p3')

???

SriNivas IT 27-Feb-13 5:08am

Actually SP has more than 50 columns and i just want to store this result very short time

Like select * from (select * from Table_Name)

mainly i want to compare result set of 2 SPs whose result set returns 17736 and 17731 rows respectively now i want to intersect result for this only.

Prakash Thirumoorthy · Answer 2 · 2013-02-26T22:55:00

Solution 2

hi,

try this coding

make sure temp table columns should same as return recordset of procedure. i.e., field type, no of fields. [ not the field name.]

SQL

create table #temp (id int)

insert  #temp execute sp_test

Select * from #temp

drop table #temp

Posted 26-Feb-13 22:55pm

Prakash Thirumoorthy

Comments

SriNivas IT 27-Feb-13 5:08am

Actually SP has more than 50 columns and i just want to store this result very short time Like select * from (select * from Table_Name) mainly i want to compare result set of 2 SPs whose result set returns 17736 and 17731 rows respectively now i want to intersect result for this only

Prakash Thirumoorthy 27-Feb-13 5:13am

if u returning 50 columns, then u have 50 columns in your temp table. and if u want only 2 fields like that, then return that 2 fields only from your sp.

SriNivas IT 27-Feb-13 5:17am

OK !

But as i say that my problem here is that

sp_1 returning rows 17736

sp_2 returning rows 17731

how i can find out which rows are extra in this huge result