TSqlForXmlSample.sql

SELECT FirstName
  , LastName
  , Email
  , Address1
  , Address2
  , City
  , State
  , PostalCode
  , Country
  , HomePhone
  , CadValue
  , NotificationCode
  , AccessLevel 
FROM ObtmMoves;

SELECT 
  (
    SELECT FirstName
    , LastName
    , Email
    , Address1
    , Address2
    , City
    , State
    , PostalCode
    , Country
    , HomePhone
    , CadValue
    , NotificationCode
    , AccessLevel 
    FROM ObtmMoves FOR XML AUTO, TYPE).query 
    ( 
      '<batch programid="3067" batchdescription="THG_PROD14" batchpromotionid="1">
      {
        for $c in /ObtmMoves
        return 
        <request>
          <createaccountrequest>
            <registration>
              <firstname>{data($c/@FirstName)}</firstname>
              <lastname>{data($c/@LastName)}</lastname>
              <email />
              <address1>{data($c/@Address1)}</address1>
              <address2>{data($c/@Address2)}</address2>
              <city>{data($c/@City)}</city>
              <state>{data($c/@State)}</state>
              <postal>{data($c/@PostalCode)}</postal>
              <country>{data($c/@Country)}</country>
              <homephone />
            </registration>
            <notificationcode>{data($c/@NotificationCode)}</notificationcode>
            <accesslevel>{data($c/@AccessLevel)}</accesslevel>
            <addenda labelid="23">TEST</addenda>
          </createaccountrequest>
          <addfundsrequest>
            <amount>{data($c/@CadValue)}</amount> 
            <taxableflag>0</taxableflag> 
            <notificationcode>0</notificationcode> 
            <directclaimflag>0</directclaimflag>
          </addfundsrequest>
        </request>
      }
      </batch>'
    )