title: How to Insert N Records in a Single Stored Procedure Call
body: <p>How would I accomplish being able to insert an unknown number of records into the database using a single stored procedure call?</p>
  
  <p>Say I have this table definition:</p>
  
  <pre><code>CREATE TABLE PHONE(
      PhoneID int identity(1,1),
      PhoneNumber varchar(20),
      PersonID int
  )
  </code></pre>
  
  <p>And I have the following insert stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE dbo.usp_Phone_Insert
      @PhoneNumber varchar(20),
      @PersonID int
  AS
  
  INSERT 
      PHONE 
  VALUES
      (@PhoneNumber, @PersonID)
  </code></pre>
  
  <p>How would I be able to transform this to insert any number of records in a single call to this stored procedure?</p>