Knowledge: Extract values from multiple choice field via SQL
Back
Knowledge
Title*Extract values from multiple choice field via SQL
ManualReporting
Created04/12/2019
Detaildeclare @xmlData xml;
declare @itemid integer = 1;
select (Repeater.Data.value('@Value','nvarchar(255)')) as ChoiceValue
from Claims Cross Apply @xmlData.nodes('//ChoiceValues/*') Repeater(Data)
where ID = @itemid
Additional Manual Locations
| Administration | Data Actions | SQL |