Insert To Omit Duplicate Records

• tom frost

  SSChasing Mays

  Points: 655

  More actions

  July 29, 2004 at 7:57 am

  #108758

  I'm in the process of writing an insert to a table which I've been having problem getting to work correctly.

  I have one table with hundreds of rows (Table A) of which I only want to insert to Table B only those that don't already exist in table B.

  Tried a not exist and various join permutations but still not getting it right.

  Any ideas?

   

  thks

   

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  July 29, 2004 at 8:21 am

  #516794

  Post your table structure and the query so far, so we can figure out.

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• tom frost

  SSChasing Mays

  Points: 655

  More actions

  July 29, 2004 at 2:15 pm

  #516875

  This is the query syntax that I've been trying to manipulate.

  insert logfilehistory(file_name,size_K,full_date,char_date,char_time)

  select fname,lsize/1024,file_date,crdate,crtime

  from #logfiles

  where not exist (select fname from #logfiles)

   

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  July 29, 2004 at 11:49 pm

  #516908

  Try this out......

  INSERT LOGFILEHISTORY (FILE_NAME,SIZE_K,FULL_DATE,CHAR_DATE,CHAR_TIME)
  SELECT FNAME,LSIZE/1024,FILE_DATE,CRDATE,CRTIME
    FROM #LOGFILES AS a
   WHERE NOT EXIST (
                      SELECT 1 
                        FROM LOGFILEHISTORY 
                       WHERE FILE_NAME = a.FNAME
                    )

  Thanks,
  Ganesh