DECLARE @x XML = '
Medical Record No. : 1165677 | Patient Name : MASTER. SURYANARAYANAN T S | Age : 16 Year(s) | Sex : male |
| Address : NO 24 KARTHGIK AVENUE 2ND STREET, TIRUMAGAL ANAGR, CHITLAPAKKAM, CHROMPET, ---, |
BACKGROUND-COLOR: #f2f2f2;">| TAMIL NADU, INDIA - 600064. |
| Report Date : 2015-05-17 | Optometrist : RAMYA S | Start Time : 2015-05-17 08:25 |
Consultant : Dr.JAYA PRAKASH V |
window.parent.document.getElementById("imgOpenHistory").click();return false;">
| Eye | Symptom Description | Duration | Unit | Onset | Progression | Remarks | Associated Symptoms |
' SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)
when i run the above code shows error as follows
XML parsing: line 22, character 2, whitespace expected
Line 22 as follows
"onclick="window.parent.document.getElementById("Base_pgContentHolder_pgContent_hdnScrnId").value="EMRFIRST";
what is the mistake in my line 22.
Nilesh ShahPosted Dec 11, 2017, 9:01 AM