title: stored procedure for inserting comma seperated values in table using ms sql?
body: <p>I have a table named assignRole.</p>
  
  <p>I am passing string of userid (int) csv ,and passing roleid(int).</p>
  
  <p>I want a stored procedure which split userid from string and take roleid and insert these values in table.this thing is to happen for all values in userid string.</p>