How to get storeprocedure result to temp table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi guys,

I am trying to get SQL Store procedure value to temp table.Please help me

I tired below solutions that not fit to my requirement. If anyone know other then this solutions please let me know

1. I tried OPENROWSET here we need to give user id and password, so i don't need that.

2. In Store procedure writing INTO statement this is also not fit for my requirement

3. Creating a table and writing exec statement with store procedure this is not a solution for my problem, because columns are dynamic in count.

Posted 25-Sep-14 19:30pm

VishwaKL

Add a Solution

Comments

george4986 26-Sep-14 1:36am

post ur code here

syed shanu 26-Sep-14 1:48am

First Tell us clearly your requirement ,why you need stored procedure result in Temp Table.You can use temp table inside your SP.for example you do some select in Sp if you want to return that select result to temp table .You can do that in SP itself .if you tell us clearly about your requirement,your table details we can help you.

VishwaKL 26-Sep-14 1:51am

which store procedure i am using i dont have access to change, i need to get that result to temp table and query that again with some conditions.

PhilLenoir 26-Sep-14 10:03am

... then create a new stored proc, call the "fixed stored proc from that, declare a temp table, and push your result into that.

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)