title: Sql Merge- How to Insert row from source table after deleting original from Target when matched?
body: <p>I currently have a stored procedure that compares my target table (Ticket_Report) to my data source table (New_Tickets).</p>
  
  <p>I am using a MERGE INTO statement to compare these two. When it finds a match between the two tables, it updates the current row in the target table with the corresponding info from the source table. If it dosent find a match, it inserts that data from the source table into the target table.</p>
  
  <pre><code>MERGE INTO Ticket_REPORT T1
  USING @New_Tickets T2
  ON T1.TICKET_NO=T2.TICKET_NO
  WHEN MATCHED THEN
  UPDATE SET 
    T1.TICKET_NO = T2.TICKET_NO, 
    T1.ASSIGNED_GROUP = T2.ASSIGNED_GROUP, 
    T1.ASSIGNEE = T2.ASSIGNEE, 
    T1.FNAME = T2.FNAME, 
    T1.LNAME = T2.LNAME
  WHEN NOT MATCHED THEN
   INSERT VALUES(
    T2.TICKET_NO, 
    T2.ASSIGNED_GROUP, 
    T2.ASSIGNEE, 
    T2.FNAME, 
    T2.LNAME
  </code></pre>
  
  <p>);</p>
  
  <p>I need to change this, so that when  match is found on the Ticket Number, instead up just updating it, I need to A.)replace the current row in the Target table by deleting it, then B.)inserting the corresponding Row from the source table.</p>
  
  <p>I currently have </p>
  
  <pre><code>MERGE INTO Ticket_REPORT T1
    USING @New_Tickets T2
    ON T1.Ticket_NO=T2.Ticket_NO
    WHEN MATCHED THEN DELETE
  //Now I need to replace what I deleted with the row from the source table
  </code></pre>
  
  <p>Which will delete the row from the Target Table. Now I want to Insert the corresponding Row from the Source Table. I am having trouble trying to do multiple things inside the WHEN MATCHED clause. Does anyone know how I can accomplish this?</p>
  
  <p>*Side note: When matched, I could Insert the row from the Source, but then I how would I delete the original?</p>