Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

INSERTED DUPLICATE RECORDS Expand / Collapse
Author
Message
Posted Wednesday, April 7, 2010 6:22 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
Gosta Munktell (4/7/2010)
From that table you can check if rows already exists in the "main" table and avoid to import them/Gosta


ahhh... you check against target table, that's cheating Gosta!
I like Ramoncito's magic process the more


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #898407
Posted Wednesday, April 7, 2010 9:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 10, 2014 4:13 AM
Points: 205, Visits: 1,339
Pablo

ahhh... you check against target table, that's cheating Gosta!
I like Ramoncito's magic process the more

I would also like to see the magic process
but I am no witch doctor.

/Gosta
Post #898645
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse