UFN_STEWARDSHIPPLAN_TOP4PARTICIPANTS_TOITEMLISTXML

create function dbo.UFN_STEWARDSHIPPLAN_TOP4PARTICIPANTS_TOITEMLISTXML
(
    @PLANID uniqueidentifier
) 
returns xml
as begin

    declare @PARTICIPANTS xml;

    set @PARTICIPANTS = (
            select
                top 4(STEWARDSHIPPLANPARTICIPANT.ID), 
                STEWARDSHIPPLANPARTICIPANT.CONSTITUENTID, 
                STEWARDSHIPPLANPARTICIPANT.ROLECODEID, 
                CONSTITUENT.NAME, 
                STEWARDSHIPPARTICIPANTROLECODE.DESCRIPTION as PLANPARTICIPANTROLECODE
            from 
                dbo.STEWARDSHIPPLANPARTICIPANT
            join dbo.CONSTITUENT 
                on STEWARDSHIPPLANPARTICIPANT.CONSTITUENTID = CONSTITUENT.ID
            left outer join dbo.STEWARDSHIPPARTICIPANTROLECODE 
                on STEWARDSHIPPLANPARTICIPANT.ROLECODEID = STEWARDSHIPPARTICIPANTROLECODE.ID

            where STEWARDSHIPPLANPARTICIPANT.PLANID = @PLANID

            order by CONSTITUENT.KEYNAME asc

            for xml raw('ITEM'), type, elements, root('PARTICIPANTS'), binary base64    
        );

        return @PARTICIPANTS;
end