title: How to Parse a comma delimited string of numbers into a temporary orderId table?
body: <p>I have a bunch of orderIds '1, 18, 1000, 77 ...' that I'm retreiving from a nvarchar(8000).  I am trying to parse this string and put the id into a temporary table.  Is there a simple and effective way to do this?<br />
  <br />
  To view a list of all the orderIds that I parsed I should be able to do this:</p>
  
  <pre>select orderid from #temp</pre>