USP_DATALIST_FISCALYEAR

CREATE procedure dbo.USP_DATALIST_FISCALYEAR
as
    set nocount on;

select t1.ID,
       YearID,
       DESCRIPTION,
       FISCALPERIODSINYEAR,
       (Select MIN(STARTDATE) from GLFISCALPERIOD as S1 where T1.ID=S1.GLFISCALYEARID ) STARTDATE,
       (Select MAX(ENDDATE) from GLFISCALPERIOD as S1 where T1.ID=S1.GLFISCALYEARID ) ENDDATE,
       STATUS
from dbo.GLFISCALYEAR As T1
Order By STARTDATE DESC