I have a table that looks like this
Col1,Col2,Col3 A, NULL,NULL A, B, NULL A, B, C
I want to translate this into a self-referencing table: something like...
ID, ParentID A, NULL B, A C, B ...
How can I achieve this? I have a few ideas, but is there a fast way? I have a lot of data to convert from the above format. THe problem isn't getting the CSV data in, it is transforming it into something more useable.
Thank you, T. Andreasen