| Author |
Topic |
|
kiekar
Starting Member
7 Posts |
 Posted - 2008-07-31 : 19:23:45
|
| Hello,Lets say I have 3 tables A, B, and C. Table A is the parent and B and C are child tables. Table A has 10 records. Is it possible to loop through table A and insert the first five id values into table B and the next five id values into table C? If this is possible, how would I go about doing this.Any help would be much appreciated...ThanksKarl |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-31 : 19:27:07
|
| No need to loop.INSERT INTO Table2 (...)SELECT TOP 5 ...FROM Table1ORDER BY SomeColumn ASCINSERT INTO Table2 (...)SELECT TOP 5 ...FROM Table1ORDER BY SomeColumn DESCBut why do you want to do this?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
kiekar
Starting Member
7 Posts |
Posted - 2008-07-31 : 20:05:35
|
| Hello Tara,Thank you for your reply. I'm just throwing some ideas in my head based on a new DB schema I want to create. This DB is based on a two dimensional table in a word document which is a checklist. Karl |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-08-01 : 00:12:55
|
| There are a few ways to achieve this, but I think you may be using the wrong approach to your design. Please describe why you want to do this and someone may be able to provide a better solution. |
|
|
|
kiekar
Starting Member
7 Posts |
Posted - 2008-08-01 : 16:01:58
|
| Hello,I've created a link which displays an image of the partial word document I want to create the db schema for. If there is anyone who can let me know if I'm going in the right direction would be much appreciated..Karl[url]http://www.enter-net.com/~kkieslin/Checklist.jpg[/url] |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-08-01 : 17:08:52
|
| If I'm understanding this correctly I would create the following tables (forgoing index, keys and such):Document (Name, whatever other high level attributes define the document)DocumentItem (DocumentItemCategoryCode, Component, Checked, QCCategory, ISARP, QCObservation, IPM_AH, Action, VerifiedBy)DocumentItemCategory (Code, Description) |
|
|
|
kiekar
Starting Member
7 Posts |
Posted - 2008-08-07 : 16:20:53
|
| Hello,I created a db schema per the previous reply. You will find a link below [url]http://www.enter-net.com/~kkieslin/RegChklist.jpg[/url].How can I insert the id's (ChecklistItemCategoryID) form the ChecklistItemCategorys table into the IARRegistrationChecklists table? Presently I have 3 different categories. When a new checklist is created, the fields are entered by one user. Once the user enters the data in the IARRegistrationChecklist table, the fields in the remaining tables are entered with null values. These fields would be entered with data later on by different users . I hope my explanation was clear enough.Any help would be much appreciated.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-08 : 01:56:10
|
quote:
Originally posted by kiekar
Hello,I created a db schema per the previous reply. You will find a link below [url]http://www.enter-net.com/~kkieslin/RegChklist.jpg[/url].How can I insert the id's (ChecklistItemCategoryID) form the ChecklistItemCategorys table into the IARRegistrationChecklists table? Presently I have 3 different categories. When a new checklist is created, the fields are entered by one user. Once the user enters the data in the IARRegistrationChecklist table, the fields in the remaining tables are entered with null values. These fields would be entered with data later on by different users . I hope my explanation was clear enough.Any help would be much appreciated.Thanks
have a look at OUTPUT clause in books online. |
|
|
|
|
Lopping through table for insertion