title: insert in same table avoid duplicate
body: <p>Below is my sql statement</p>
  
  <pre><code>INSERT INTO tblRB_ReportFilterUserAssoc (
      [FK_ReportID],
      [UserID],
      [FilterExpression],
      [DateFilterValues],
      [IsCustomReport]
      )
  SELECT [FK_ReportID],
      @UserId,
      [FilterExpression],
      [DateFilterValues],
      [IsCustomReport]
  FROM tblRB_ReportFilterUserAssoc
  WHERE UserID = @AssignedUserID
  </code></pre>
  
  <p>there is condition of UserID</p>
  
  <p>it is basically inserting all the records in same records of a particular user for another user</p>
  
  <p>i have to check if the particular filter is exist for new user then dont insert</p>
  
  <p>case</p>
  
  <p>how can i do that</p>
  
  <pre>
  [FK_ReportID]  user_id
  1                   100
  2                   100
  3                   100
  1                   101   
  </pre>        
  
  <p>now i want to insert all records of userid 100 to same table for userid 101, but as report id 1 is already there in table for 101 so it should insert only records for 2,3,4</p>
  
  <p>how should we restrict that</p>
  
  <p>Thank You           </p>