SQl Query... Multiple Cols To Single XML.

Hi I have a table which has couple of name cols and 10 varchar columns. The requirement was to retain the first two cols but convert the 10 cols into a single XMl.

the table has this schema;


ManagerName varchar
UserName varchar
TextField1 Varchar
TextField2 Varchar
TextField3 Varchar
TextField4 Varchar
TextField5 Varchar
TextField6 Varchar
TextField7 Varchar
TextField8 Varchar
TextField9 Varchar
TextField10 Varchar

I wrote a query like;

SELECT

TPD.[NameId]
,CrtdUser.[UserId]
from [Olddb_DB] TPD
join

[NewDB]..[Manager]CrtdUser
on
Crtduser.managerName = TPD.ManagerName
join
[NewDB]..[Users]Users

on
Users.[loginDetail] = TPD.[UserName]


to get the cols other than the XML

/*********/

SELECT

XmlDat.[textField1],

XmlDat.[textField2],

XmlDat.[textField3],

XmlDat.[textField4],

XmlDat.[textField5],

XmlDat.[textField6],

XmlDat.[textField7],

XmlDat.[textField8],

XmlDat.[textField9],

XmlDat.[textField10],

XmlDat.[textField11],

XmlDat.[textField12]

from

[olddb_db]..[DETAIL_DEF] XmlDat,[NEWDB]..[Detail_Def]TPD

where TPD.Name = XmlDat.Name

for XML AUTO, ELEMENTS

and this query to convert all the varchar cols to a XML. Now the problem is I am not sure of how to combine both these queries to Insert into the new table.

Can someone guide me in this

the destination table looks like

Name (Varchar)

UserId (int)

UserVal_XMl (XML)





Thanks in advance