title: Stop Inserting in Table if record already exists
body: <p>I have sql server procedure, please see below.</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[uspInsertDelegate]
  (
      @CourseID int,
      @CPUserID int,
      @StatusID int,
      @CreateUser varchar(25)
  
  )
  AS
      SET NOCOUNT OFF;
  INSERT INTO tblDelegate                      
  (
      CourseID, 
      CPUserID, 
      StatusID, 
      CreateUser 
  
  )
  VALUES     
  (
      @CourseID,
      @CPUserID,
      @StatusID,
      @CreateUser
  )
  
  RETURN
  </code></pre>
  
  <p>Now I don't want to insert into table <strong>tblDelegate</strong> if the inserting <strong>courseid</strong> and <strong>cpuserid</strong> is same for that records in table tblDelegate</p>