|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
August 28th, 2004, 02:20 PM
|
|||
|
|||
Copy Records
I have 1 table. In that table there are thousands of records. I have an ID that is autonumbered for a unique id.
What i need to do is at any given time select as many records from that table that have a certain Forein Key in it. Take all those records and copy them back into the same table but at that time i need to change some of the values including the Forien Key and the name. Is there a bulk way to do this without having to loop? If so can you show me. If not can someone show me the best way to get all the records and copy them back into its own talbe with a new Forien Key and Name.
|
|
#3
August 30th, 2004, 12:44 PM
|
|||
|
|||
|
Quote:
Yes that was it. I figured it out. I've done it before but it had been a while. Thank you.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Copy Records |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
