How Read data from XML variable in Sqlserver and show in table format?

Question

I have below format of xml.

enter image description here

need to show this data below table format.

Table Format

msdn.microsoft.com/pl-pl/library/ms175160.aspx , stackoverflow.com/questions/9997520/…, informit.com/articles/article.aspx?p=26499 — Emilio Gort
– Emilio Gort, Commented Sep 30, 2013 at 11:01
I have changes in the XML now it's validate properly, sorry in emergency I have added wrong XML. — KuldipMCA
– KuldipMCA, Commented Sep 30, 2013 at 11:41

podiluska · Accepted Answer · 2013-09-30 11:13:37Z

11

Once you've made your XML valid, use nodes

select 
    t.x.value('FacilityID[1]','int') as FacilityID,
    t.x.value('Category[1]','int') as CategryID
from @yourxml.nodes('/Facilities/Facility') t(x)

answered Sep 30, 2013 at 11:13

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How Read data from XML variable in Sqlserver and show in table format?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related