UFN_MEMBERSHIPDUESBATCH_GETCHILDREN_TOITEMLISTXML

CREATE function dbo.UFN_MEMBERSHIPDUESBATCH_GETCHILDREN_TOITEMLISTXML
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier,
    @SOURCECONSTITUENTID uniqueidentifier
)
returns xml
as begin
    declare @XML xml;

    set @XML = (
        select 
            ID,
            CONSTITUENTID,
            RELATIONTOPRIMARY,
            AGE
        from dbo.UFN_MEMBERSHIPDUESBATCH_GETCHILDREN(@BATCHMEMBERSHIPDUESID, @SOURCECONSTITUENTID)
        for xml raw('ITEM'),type,elements,root('EXISTINGCHILDREN'),BINARY BASE64
    );

    --set @XML = isnull(@XML, '<EXISTINGCHILDREN></EXISTINGCHILDREN>');


    return @XML;
end