Viewing 2 posts - 1 through 3 (of 3 total)
Problem solved, the select needed /text() for all values:
product.value('(products_mpn/text())[1]', 'NVARCHAR(256)'),
November 1, 2016 at 1:05 pm
#1909986
After some debugging trying to remove the insert part and only using select to see the result it seems to be the INSERT being the problem, because without it I...
November 1, 2016 at 12:51 pm
#1909981