title: Create temp table from comma separated values with more than one column
body: <p>I'm trying to pass a comma separated string such as this: "101:string1,102:string2" into a stored proc and create a temp table out of it. The temp table would have two columns, one integer and one string. It would have two rows for this example. The comma delimits the rows, and the colons delimit the two columns. Anyone know how I can do this? I'm using sql server. Thanks in advance!</p>
  
  <p>EDIT: By the way, I'm not asking about how to create a temp table, only how to create the function.</p>