Eirikur Eiriksson
SSC Guru
Points: 182951
More actions
July 15, 2016 at 4:00 am
#1890255
Quick suggestion
😎
SELECT ids.DataSet.value('(./text())[1]','INT') AS ID
FROM @IDs.nodes('/IDs/ID') AS ids(DataSet)
Bruceo
SSCrazy
Points: 2152
July 15, 2016 at 4:10 am
#1890260
That is what I was looking for!
Need to work on my XQuery knowledge.
thanks for the help 😉
July 15, 2016 at 4:20 am
#1890262
You are very welcome.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply