"Jonathan Leffler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Fri, 11 Feb 2005 08:10:25 -0500, Robert <[EMAIL PROTECTED]> wrote: >> Let me see if I can explain it better today. :-) > > See: http://www.catb.org/~esr/faqs/smart-questions.html > >> I have about 200 users in "district 1". I need to add each of those users >> into "district 2" using the same information that they have in "district >> 1". >> I also need to make sure they are only inserted 1 time. They have a >> unique >> employeeID, so I know I can use that to make sure that they are inserted >> 1 >> time. > > You do have a unique constraint that would prevent duplicates from > being entered, don't you? So, if you try to insert a duplicate entry, > the DBMS will reject the second entry. > > Since you seem to need to repeat the data, you should probably revisit > your database design - you probably need a list of users and their <snip>
Oh I wish I could! I am constrained by a 3rd party application that uses Oracle as a big ole flat file. Where every table is padding with spaces! Every table. I could shoot the people that created this application. You would barf into my trashcan if you saw how the back-end is arranged. Robert
