<ClinicalDocument xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:hl7-org:v3" xmlns:voc="urn:hl7-org:v3/voc" xmlns:sdtc="urn:hl7-org:sdtc"> <code code="185349003" codeSystem="2.16.840.1.113883.6.96" sdtc:valueSet="2.16.840.1.113883.3.464.1003.101.12.1048"> <originalText>Encounter, Performed: Diabetes Visit</originalText> </code> </ClinicalDocument>
DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX),@rootxmlns varchar(100) SET @rootxmlns = '<root xmlns:hm="urn:hl7-org:v3" />' SELECT @XML ='<ClinicalDocument xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:hl7-org:v3" xmlns:voc="urn:hl7-org:v3/voc" xmlns:sdtc="urn:hl7-org:sdtc"> <code code="185349003" codeSystem="2.16.840.1.113883.6.96" sdtc:valueSet="2.16.840.1.113883.3.464.1003.101.12.1048"> <originalText>Encounter, Performed: Diabetes Visit</originalText> </code> </ClinicalDocument>' EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML,@rootxmlns SELECT * FROM OPENXML (@hDoc, '//hm:ClinicalDocument') with( Value_setid varchar(50) 'hm:code/@hm:valueSet', originalText varchar(50) 'hm:code/hm:originalText' )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)