title: Insert multiple rows in Database table using T-sql
body: <p>I want to create SQL statement (probably a stored procedure) to insert multiple rows in a database table. For the dates in one year depending on the weeks number selected.</p>
  
  <p><strong>For example:</strong>
  if Week number selected = 4</p>
  
  <p>The sql statement should insert the new rows in database table for the current date adding 4 weeks to current date for each row as follows:</p>
  
  <pre><code>CompanyID  DateStart                  ServiceType
  
  101       todayDate                     0091
  101       TodayDate + 4weeks            0091
  101       TodayDate + 8weeks            0091
  101       TodayDate + 12weeks           0091
  .               .                          .
  .               .                          .
  .               .                          .
  101       TodayDate + #weeks            0091
              (until this yearEnd only)
  </code></pre>
  
  <p>**
  <strong>Please NOTE:</strong></p>
  
  <p>1.
  Before the above script is executed I want to check if there are any records in the same database table for previous year 
  for the company (#101) the serviceType (#0091). If any records exists I want to delete those records.</p>
  
  <p>2.
  I also want to make sure if for the service type (#0091) for the company(101) already exists in the current year, then I <strong>should not insert</strong> the new rows in the database table.</p>
  
  <p>Thank you so much for your help for taking time and understanding my question to produce appropriate result.</p>