XML format output

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Russel Loski SSCertifiable Points: 7059 More actions · Answer 1

Try this.

create table Menu (ParentID int, ID int, menuText varchar(100) , href varchar(100))

insert into Menu values (null, 1, 'Button1', null)

insert into Menu values (null, 2, 'Button2', null)

insert into Menu values (1, 3, 'Sub1', 'index.html')

insert into Menu values (1, 4, 'Sub2', 'index.html')

insert into Menu values (2, 5, 'Suba', 'index.html')

insert into Menu values (2, 6, 'Subb', 'index.html')

select menuText [@text],

(select href as [@href], menuText as [@text]

from Menu ms where ms.ParentID = mt.ID

for xml path ('menuItem'), Type

)

from Menu mt

where ParentID is null

for xml path ('topMenu'), root ('rootMenu')

Russel Loski, MCSE Business Intelligence, Data Platform

grovelli-262555 SSCrazy Points: 2633 More actions · Answer 2

?

Russel Loski SSCertifiable Points: 7059 More actions · Answer 3

Is it the same "Type" that is mentioned in the other post? Yes.

Russel Loski, MCSE Business Intelligence, Data Platform