I have a csv file that is input into a varchar(max) column in an Azure SQL Database table. When the file is inserted into this table column I would like to take the data in this column, parse it and insert its contents into various columns of another table.
Would I create an after insert trigger, get the column data, loop through it and add the elements to a list, array or some other collection (if SQL has such a thing) and then perform an insert into the other table using the collection? Or is their a better way?
My apologies if this is a stupid question but until very recently my SQL skills have been relegated to CRUD operations so I have a lot to learn.