I have a table (Table1) which has a coloumn by name XMLColoumn a part of the xml is like
My table is (Table1)
I am trying to get output as
I am trying to do something like
Which returns me only the first row ie maths..how can i get all the
Please let me know i tried a lot to find...but couldnt.Please help!
You need to use CROSS APPLY to expand the nodes of the XML column. i.e.
Moreover, I do not know your environment but having student subjects in xml format seems to be a very bad option as it makes a bad schema design.
answered Apr 26, 2012 at 04:26 AM