Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
estanuk
Starting Member
3 Posts |
 Posted - 2008-10-29 : 12:36:30
|
| Hi all,Having a bit of trouble getting my head around a rather big query I need to do, I'll start from the top:I have a database that i have copied 8 of the table structures from into a blank database, I now need to 'cut and paste' the records so to speak that are before a certain date criteria.I have done a select join statement that returns all the records from all 8 tables that are all linked based on a specific record number. The records have been returned fine, i now need to figure out the best way to get all these records into the relevant tables on the other database, then preferably drop them after.Any recommedations/advice?Many thanksEd |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-29 : 12:39:23
|
| no need of join if data should go to8 tables. you need seperate insert statements for each table. |
 |
|
|
estanuk
Starting Member
3 Posts |
Posted - 2008-10-29 : 13:19:00
|
| forigve me for being stupid, however the other tables do not contain a date field, they are all linked in from the one unique number field on the first table, so how would i go about doing this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-29 : 13:24:03
|
| then you might need join to table containing date field for those which dont have date field. |
|
|
|
|
|
|
Big insert join query from 1 db to another!