sun8426
July 24th, 2008, 10:48 AM
Hello all,
I created a new table with an uniqueIdentifier field. I populated this table from 3 existing tables that have a field named global_id that is also an uniqueIdentifier field. after I am done with the insert statement, I found there was a record that has the same value as the global_id was imported into the new table 3 times because that record was exist in the 3 tables. Could someone explain to why how could this record was imported to the table 3 times if I set the global_id as a uniqueidentifier field??
thanks
Sherry
I created a new table with an uniqueIdentifier field. I populated this table from 3 existing tables that have a field named global_id that is also an uniqueIdentifier field. after I am done with the insert statement, I found there was a record that has the same value as the global_id was imported into the new table 3 times because that record was exist in the 3 tables. Could someone explain to why how could this record was imported to the table 3 times if I set the global_id as a uniqueidentifier field??
thanks
Sherry