title: The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint
body: <p>I have created table <code>Employee</code></p>
  
  <pre><code>Create table Employee
  (   
      FName varchar(20) Not Null,
      LName varchar(20) Not Null,
      SSN int Not Null,
      BDate Datetime,
      Address varchar(50),
      Sex char(1),
      Salary money,
      Super_SSN int,
      Primary Key(SSN),
      Foreign Key(Super_SSN) references Employee(SSN)
  )
  </code></pre>
  
  <p>When i try to insert first row to ,</p>
  
  <pre><code>insert into Employee(FName,LName,SSN,BDate,Address,Sex,Salary,Super_SSN)
  values('John','Smith',12345,'1965-01-09','Houston,TX','M',30000,33344) 
  </code></pre>
  
  <p>I am getting the error like..</p>
  
  <p><strong>Error:</strong></p>
  
  <blockquote>
    <p>The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_Employee_Employee". The conflict occurred in database "Company", table "dbo.Employee", column 'SSN'.</p>
  </blockquote>