I need to insert a comma delimited list into a temp table with one record per element. So, data like this:- '1664339','1602531','1604891','1604743','3692983','5702028','1605330','1605431','1605225','4695246','1601455'
Would need to go into a temp table as separate records.
I currently have around 1500 items in my current list so loopin through will take a while and is probably not the best solution.
I know I've seen some code that will do this, but I can't seem to find it using Google (probably using the wrong search terms).
Would someone point me in the right direction please?