title: Trying to insert data correctly
body: <p>After receiving very good correction from fuzzy lollipop, I amended my code to create an insert statement for every row of data.  This is the code that I entered:</p>
  
  <pre><code>INSERT DEPARTMENTS
  (Department_Id,Department_Name,Manager_Id,Location_Id)
  VALUES
  ('D0001','Think Tank',NULL,'L0001')
  GO
  
  INSERT DEPARTMENTS
  (Department_Id,Department_Name,Manager_Id,Location_Id)
  VALUES
  ('D0002','Creators',NULL,'L0002')
  GO
  
  INSERT DEPARTMENTS
  (Department_Id,Department_Name,Manager_Id,Location_Id)
  VALUES
  ('D0003','Marketers',NULL,'L0003')
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0001','Joe','Blow',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0002','John','Doe',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0003','Sue','Happy',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0004','Tina','Turner',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0005','Ike','Turner',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0006','Big','Bird',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  
  INSERT EMPLOYEES
  (Employee_Id,First_Name,Last_Name,Email,PhoneNumber,Hire_Date,Manager_ID,Department_Id)
  VALUES
  ('E0007','Speedy','Gonzales',NULL,NULL,2010/06/25,NULL,NULL)
  GO
  </code></pre>
  
  <p>However, these were the error messages that I received:</p>
  
  <pre><code>Msg 547, Level 16, State 0, Line 1
  The INSERT statement conflicted with the FOREIGN KEY constraint "FK__DEPARTMEN__Locat__09DE7BCC". The conflict occurred in database "Final_Project", table "dbo.LOCATIONS", column 'Location_ID'.
  The statement has been terminated.
  Msg 547, Level 16, State 0, Line 2
  The INSERT statement conflicted with the FOREIGN KEY constraint "FK__DEPARTMEN__Locat__09DE7BCC". The conflict occurred in database "Final_Project", table "dbo.LOCATIONS", column 'Location_ID'.
  The statement has been terminated.
  Msg 547, Level 16, State 0, Line 2
  The INSERT statement conflicted with the FOREIGN KEY constraint "FK__DEPARTMEN__Locat__09DE7BCC". The conflict occurred in database "Final_Project", table "dbo.LOCATIONS", column 'Location_ID'.
  The statement has been terminated.
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  Msg 206, Level 16, State 2, Line 2
  Operand type clash: int is incompatible with date
  </code></pre>
  
  <p>I won’t make the same mistake by failing to respond immediately to solutions.  I did not know the checking the green checkmark meant that the answer was satisfactory.</p>
  
  <p>Thank you for any help</p>