title: insert to sql db (no duplicate)
body: <p>i've problem with inserting data to my db. i wanna know how can i add only data which not already in the table??</p>
  
  <pre><code>INSERT  INTO dbo.Posta
      (
          DrzavaID,
          PostnaStevilka,
          Naziv,
          record_dt_modified,
          record_modifier_id,
          record_dt_created,
          record_creator_id
      )
  
      select 
          d.DrzavaID,
          p.PostnaSt, 
          concat(CONCAT(p.Provinca,+' - '+p.Okrozje),+' - '+p.Mesto),
          @record_dt_modified,
          @record_modifier_id,
          @record_dt_modified,
          @record_modifier_id
      FROM mmdb_kopijaSI.dbo.Drzava d,#PostaT p
      WHERE d.Kratica='TR';
  </code></pre>
  
  <hr>
  
  <pre><code>alter PROCEDURE addPosta 
  AS
  BEGIN
  insert into #PostaT values( 'ADANA','ALADA?(KARSANTI)','AKÖREN',1720 );
  insert into #PostaT values( 'ADANA','ALADA?(KARSANTI)','KARSANTI',1720 );
  insert into #PostaT values( 'ADANA','ALADA?(KARSANTI)','MERKEZKÖYLER',1720 );
  insert into #PostaT values( 'ADANA','CEYHAN','B?RKENT',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','BÜYÜKMANGIT',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','CEYHAN',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','DORUK',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','EMEK',1940 );
  insert into #PostaT values( 'ADANA','CEYHAN','HAMD?LL?',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','KÖSREL?',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','KURTKULA?I',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','KURTPINAR',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','MERC?MEK',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','MERKEZKÖYLER',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','MUSTAFABEYL?',1920 );
  insert into #PostaT values( 'ADANA','CEYHAN','NAMIKKEMAL',1950 );
  </code></pre>
  
  <p>.
  ..
  ...to 10000 inserts</p>
  
  <pre><code>CREATE TABLE #PostaT
      (
          Provinca varchar(20),
          Okrozje varchar(20),
          Mesto varchar(20),
          PostnaSt int
      )
  
      exec [PosteZaPoseg];
  </code></pre>
  
  <p>i fill my table with procedure with about 10000 items. I wanna fill the table only with data from Procedure [PosteZaPoseg] which is not in table</p>