title: Insert multiple columns with multiple values using stored procedure in SQL Server 2008
body: <p>We are passing 4 parameters to a stored procedure</p>
  
  <pre><code>@PageID,
  @CompanyID,
  @URL, 
  @URLCode,
  </code></pre>
  
  <p>All these parameters contains comma-separated values</p>
  
  <p>Example:</p>
  
  <pre><code> @PageID contains ("1,2,3,4,5,6,7")
   @CompanyID contains ("10,20,30,40,50,60,70") 
   @URL contains ("u1,u2,u3,u4,u5,u6,u7")
   @URLCode contains ("c1,c2,c3,c4,c5,c6,c7") 
  </code></pre>
  
  <p>In database I have one table as mentioned below:</p>
  
  <p>Table name : <code>UrlMapping</code></p>
  
  <p>Columns: </p>
  
  <pre><code>MappingID (PK), 
  PageID, 
  CompanyID,
  URL,
  UrlCode
  </code></pre>
  
  <p>Can you suggest how can insert these multiple comma separated values in <code>UrlMapping</code> table.</p>