USP_DATALIST_AGINGBUCKETSAP

CREATE procedure dbo.USP_DATALIST_AGINGBUCKETSAP
as
    set nocount on;

        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 = 1