UFN_MEMBERSHIPDUESBATCH_GETMEMBERS_TOITEMLISTXML

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

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

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


    return @XML;
end