UFN_FAFEVENT_GETREGISTRATIONOPTION_TOITEMLISTXML

CREATE function dbo.UFN_FAFEVENT_GETREGISTRATIONOPTION_TOITEMLISTXML(@EVENTID uniqueidentifier)
returns XML
  as begin
    return (
    select
      '00000000-0000-0000-0000-000000000000' as ID, 
      EVENTPRICE.ID as COPYSOURCEID, 
      @EVENTID as COPYBATCHGUID, 
      NAME,
      EVENTREGISTRATIONTYPEID,
      REGISTRATIONCOUNT,
      AMOUNT,
      RECEIPTAMOUNT,
      ISACTIVE,
      DESCRIPTION,
      ISNOTAVAILABLEONLINEREG,
      ISREGTYPEAVAILABLEINDIVIDUAL,
      ISREGTYPEAVAILABLEFAMILYMEMBER,
      ISREGTYPEAVAILABLEHEADHOUSEHOLD,
        ISREGTYPEAVAILABLETEAMMEMBER,
      ISREGTYPEAVAILABLETEAMLEADER,
      ISREGTYPEAVAILABLECOMPANYLEADER,
      Null as EARLYREGISTRATIONDATE,
      EARLYREGISTRATIONDISCOUNT,
      Null as LATEFEEDATE,
      LATEFEE,
      TURNONWAITLIST,
      DISPLAYSPOTSAVAILABLE,
      SENDEVENTCONTACTALERTMAXREACHED,
      WAITLISTMESSAGE,
      MINIMUMAGE,
      MAXIMUMAGE, 
        FAFREGISTRATIONCATEGORYID,
      MAXQUANTITY,
      USEDQUANTITY,
      ALLOWPARTICIPANTSWAIVEBENEFITS,
      dbo.UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS_TOITEMLISTXML(EVENTPRICE.ID) 
    from dbo.EVENTPRICE
    join dbo.FAFREGISTRATIONTYPE on EVENTPRICE.ID = FAFREGISTRATIONTYPE.EVENTPRICEID
    where EVENTPRICE.EVENTID = @EVENTID
    for xml raw('OPTION'),type,elements,root('REGISTRATIONOPTIONS'),BINARY BASE64
    )
    end