UFN_ORGANIZATIONHIERARCHY_TOITEMLISTXML

        create function dbo.UFN_ORGANIZATIONHIERARCHY_TOITEMLISTXML()
        returns xml
        as
        BEGIN

        RETURN (
            select    ORGANIZATIONHIERARCHY.[ID], 
                    ORGANIZATIONHIERARCHY.[PARENTID], 
                    ORGANIZATIONHIERARCHY.[SEQUENCE],
                    ORGANIZATIONPOSITION.NAME, 
                    ORGANIZATIONPOSITION.SITEID,
                        (select ORGANIZATIONPOSITIONHOLDER.ID, ORGANIZATIONPOSITIONHOLDER.CONSTITUENTID, ORGANIZATIONPOSITIONHOLDER.DATEFROM, ORGANIZATIONPOSITIONHOLDER.DATETO
                         from dbo.ORGANIZATIONPOSITIONHOLDER
                            where ORGANIZATIONPOSITIONHOLDER.POSITIONID = ORGANIZATIONPOSITION.ID
                         for xml raw('ITEM'),type,elements,root('POSITIONHOLDERS'),BINARY BASE64)
             from dbo.ORGANIZATIONHIERARCHY
             left outer join dbo.ORGANIZATIONPOSITION
                    on ORGANIZATIONPOSITION.ID = ORGANIZATIONHIERARCHY.ID
             for xml raw('ITEM'),type,elements,root('ORGANIZATIONHIERARCHY'),BINARY BASE64
        )

        END