title: Select the rows that just inserted
body: <p>How can I retrieve the row just inserted?</p>
  
  <pre><code>INSERT INTO LETTRE_VOIT
  select rsVoit.NOID, NO_ORDRE, rsOrdre.CODE_DEST, rsOrdre.MODAL_MODE, rsOrdre.MODAL_PORT,
  CASE rsOrdre.MODAL_PORT
              WHEN 'false' THEN 'D'
              ELSE 'P'
          END, 
  rsOrdre.LIVRS_EXPRS,
  CASE rsOrdre.LIVRS_EXPRS
              WHEN 'false' THEN 'L'
              ELSE 'E'
          END, 
    rsOrdre.ENLEV_UNITE, LIBELLE, NBR_COLIS,POID,ENLEV_CREMB,ENLEV_DECL
  from ORDRE rsOrdre
  inner join
  (
    select CODE_DEST,MODAL_MODE, MODAL_PORT, LIVRS_EXPRS,ENLEV_UNITE, ROW_NUMBER() over (order by CODE_DEST) as NOID
    from ORDRE
    group by CODE_DEST,MODAL_MODE,MODAL_PORT,LIVRS_EXPRS,ENLEV_UNITE
  ) rsVoit on rsVoit.CODE_DEST = rsOrdre.CODE_DEST and rsVoit.MODAL_MODE = rsOrdre.MODAL_MODE
  and rsVoit.MODAL_PORT = rsOrdre.MODAL_PORT and rsVoit.LIVRS_EXPRS = rsOrdre.LIVRS_EXPRS
  and rsVoit.ENLEV_UNITE = rsOrdre.ENLEV_UNITE
  
  LEFT JOIN T_UNITE ON rsOrdre.ENLEV_UNITE = T_UNITE.NOID
  WHERE (STATUT_ORDRE = 3) AND IS_PRINT = 'false' AND (TRANSPORTEUR IN (SELECT ParsedString From dbo.ParseStringList(@Trans)))
  order by rsVoit.NOID, NO_ORDRE
  
  SELECT * FROM LETTRE_VOIT WHERE ???
  </code></pre>
  
  <p>For example:</p>
  
  <p>I inserted 2, it return 2 </p>
  
  <p>and then I inserted 3, I want return 3 instead of 5 rows.</p>
  
  <p>Thanks in advance.</p>
  
  <p>Stev </p>
  
  <p>PS: May be I need to use a stored procedure ?</p>