How to select data from xml data

21

check your private message I sent for you to email me your xml file.

22

pretty complicated xml

select v.value('local-name(.)', 'varchar(50)') as nodename,
       null,
	   x.v.value('@url','char(150)')         
  from @fakenews.nodes('/searchResult/section/item') x(v)
 union 
select  v.value('local-name(.)', 'varchar(50)') as nodename,
        x.v.value('@type','char(150)')   ,
		x.v.value('@url','char(150)')    
  from @fakenews.nodes('/searchResult/section/block') x(v)
  cross apply @fakenews.nodes('/searchResult/section/block/item') a(b)
23

i need only topstories....please help me

24

i sent you a direct message. email me your xml...

25

mailid please...

26

check your private message. here is where you go to check your Inbox on https://forums.sqlteam.com

27

problem solved ...thank you for your support.