I have a SQL Server 2008 table (myTableA) with a field (Notes) that has data separated with commas:
Sample data: UPS, FedEx,DHL
I want to insert the data into a column in another table myTableB with each one being it's own row:
How can I do this?
Thank you in advance!