I have XML in SQL, I want the below result from the query. TabSeq Path SubTabSeq 1 //Tab/Family 1 1 //Tab/Location 2 2 //Tab/Address 1 2 //Tab/Insurance 2 Below is the XML. <Tabs> <Tab sequence="001"> <Family sequence="001"> <Data>Yes</Data> </Family> <Location sequence="002"> <Data>USA</Data> </Location> </Tab> <Tab sequence="002"> <Address sequence="001"> <Data>XYZ</Data> </Address> <Insurance sequence="002"> <Data>Yes</Data> </Insurance> </Tab>… Read More Extract child node value using SQL QUERY