UFN_AGINGBUCKET_PERIODLISTXML

        create function dbo.UFN_AGINGBUCKET_PERIODLISTXML
            (
                @APPLICATIONCODE tinyint
            )
        returns xml
        with execute as caller
        as begin
            declare @XML xml
            set @XML = (
            select ID, PERIODNUMBER, PERIODSTART, 
            case when  PERIODEND = 32767  then 'over' else CAST(PERIODEND as nvarchar(10)) end as 'PERIODEND', 
            PERIODDESCRIPTION 
            from dbo.AGINGBUCKET
            where APPLICATIONCODE = @APPLICATIONCODE 
            order by PERIODNUMBER
            for xml raw('ITEM'), type, elements, root('AGINGBUCKETAPXML'), BINARY BASE64)
            return @XML
        end