How to insert data into a table from stored procedure?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Dear Friends,

I am facing problem while adding/inserting data from a stored procedure into a table.

I am using the command as under:-

insert @temp_Item_Indent_Details exec sp_item_indents_description @itemL4Id

Where @temp_Item_Indent_Details=temporary table, @sp_item_indents_description=stored procedure and @itemL4Id=stored procedure parameter

What is the procedure and the set of instructions required to perform the same function?

Thanks

Varun Sareen
Software Developer

Posted 10-Oct-10 23:08pm

Varun Sareen

Updated 11-Oct-10 0:34am

v3

Add a Solution

1 solution

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)

Ankur^\m/ · Accepted Answer · 2010-10-11T00:03:00

Solution 1

Can you give more details about the problem that you are facing?

Moreover, a simple Google search will tell you how to create and use stored procedure in your application.

Posted 11-Oct-10 0:03am

Ankur^\m/

Comments

Varun Sareen 11-Oct-10 6:22am

Dear Ankur

I am making a stored procedure that requires data from another stored procedure; that i need to put into a temporary table and have to do some cursor level programming on the data inserted into the temporary table but i am not able to perform the same operation. And if i have found a concrete answer from google search then i would not have posted my query on codeproject.

Kindly help.

Thanks

Ankur^\m/ 11-Oct-10 6:36am

Hi Varun,
Do you realise that you haven't given much details here. Saying that you are facing problem with something doesn't help much. You need to provide the code that you tried. You also need to give error details if any.
Add more details to the question.
And about the Google thing, search for "adding/inserting data from a stored procedure into a table" (an extract from your question) and see what you get.

Hope this makes sense.

Varun Sareen 11-Oct-10 6:51am

Thanks dear Ankur for the concern but i got the answer myself. It was only due to the no of columns that i was making in the new table structure was wrong.

Ankur^\m/ 11-Oct-10 6:59am

I am glad to hear that you got it working.
We, sometimes, are so lazy to look into the issue because we know someone would give an answer in the forum and later realise that it was a silly mistake. Please don't take it otherwise. I just want to say that trying hard can make anything possible. :thumbsup:
Cheers!

Varun Sareen 16-Oct-10 2:54am

Thanks dear Ankur :).