Sorry for the late reply.

I have table like this

create table CarModel

(Brand varchar(200),

Model varchar(500),

Color varchar(100),

Price money,

TotalQty int,

SequenceNum int)

Insert into CarModel

(Brand, Model,Color, Price,TotalQty,SequenceNum)

values

('Nissan','Quest','Smoke',25000,25,2),

('Nisaan','Leaf','Black',21000,10,1),

('Honda','Civic','Red',25000,10,1),

('Toyota','Camry','White',30000,12,2),

('Toyota','Corolla','Green',12000,30,1),

('Hundai','Sonata','Red',23000,9,1),

('Nisaan','Rouge','Silver',32000,15,3)

and like to get the xml out like below

Update Database="Warehouse"...