Hi, I need to import/merge a table into multiple tables in the same database. I don't really know ssis so I thought I'll do it in steps using tsql scripts. I have a column, that has data like below
"Breast Sarcoma Head and Neck Prostate Malignancies"
I want to import this data into a table that has a personId column and a column for each of the item above that is separated by 2 spaces. How can I do that in query? Thank you. the entries in the table inserted to would have something like this for above:
personID Treatment area
10001 Head and Neck
10001 Prostate Malignancies