I am trying to add multiple values to a multiple metadata column via SQL using a third party migration tool (Layer 2), but it only works when I add one value as explained below.
I have written some testing code like this in SQL
(Where Qualifications is the termset and BA and BSc are the terms)
And it works with just the one value with the SQL shown above.
However, I want this
To try to do this, I have amended the SQL like so
,'Qualifications;BA; Qualifications;Bsc '
But sharepoint does not attempt the format and wont add any values
The error I get back from the software is
Does anyone know what the SQL should be to make this work, if possible?