title: for each in MS SQL SERVER?
body: <p>I have two tables:</p>
  
  <p><code>Employees(EmployeeID, EmployeeName, EmployeeStatus, BasicSalary)</code> and </p>
  
  <p><code>EmployeePayroll (PayrollID, EmployeeID, VoucherNo, BasicSalary, SalaryMonth)</code></p>
  
  <p>I want to make a <code>for each</code> loop for every employee in the first table so that I can insert dummy data like <code>(0, EmployeeID,0 ,0 ,0)</code> into the second table.</p>
  
  <p>I tried to make it with a <code>for</code> loop but I could not make it, so is there a <code>for each</code> loop in MS SQL Server??</p>