How to get values inserted into temp table to my original table in sql server 2008 r2

Question

0.00/5 (No votes)

See more:

I want to create a temp table in my stored procedure in which one field is i am getting using scope_identity() other field is itself an identity. What i want is that the temp table should get rows (which are multiple ) corresponding to the single value of scope identity. like

HTML

columnA ColumnB

111        X

111        Y

111        z

and then i want these values to be inserted into my original table. Is it possible How?

Thank you

Posted 14-Oct-13 20:44pm

Rambo_Raja

Updated 14-Oct-13 20:50pm

Kenneth Haugland

v2

Add a Solution

Comments

coded007 15-Oct-13 2:55am

Can you give any demo code and explain more clearly

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)

Mehdy Moini · Answer 1 · 2013-10-15T09:58:00

If you use scope identity for storing another table identity field,and then you want to insert it's value to your temp table, you should consider that if your temp table has also an identity column, the value of scope identity is changing during each insertion to temp table,
so you must store the value of scope identity in another variable and then use it for insertion.

as a solution you can store scope identity into another variable.