question

madhua531 avatar image
madhua531 asked

insert records from one table t o another table but existing multiple records

ihave two tables is there t1 & t2 t1 id name 1 a 2 b 3 c 4 d 5 e t2 id name 1 a 1 a 2 b 2 b 3 c 3 c 4 d 5 e but my result is t2 id name 1 a 1 a 2 b 2 b 3 c 3 c 4 d 4 d 5 e 5 e
sql-server-2008resultsinline-table-valued-functionnot-exists
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you provide the code or more details? Your request is not clear.
0 Likes 0 ·
Could you explain a little further what it is you expect to do? It sounds like you might be looking for the MERGE statement, but I'm not sure. http://msdn.microsoft.com/en-us/library/bb510625.aspx
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.