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?  

To view a list of all the orderIds that I parsed I should be able to do this:

```
select orderid from #temp
```