Hi all, I have a table of 2 columns of strings, with example row as:
Col1 Col2 123 23,34,45,67... up to around 1 million I'd like to expand the comma separated values to a new taller KVP table: Col1 Col2 123 23 123 34 123 45 123 67 123 .... potentially 1,000,000 rows generated Can someone please point me in the right direction? Thanks Tim
