USP_DATALIST_BILLINGITEM_FLATRATE_COSTHISTORY

CREATE procedure dbo.USP_DATALIST_BILLINGITEM_FLATRATE_COSTHISTORY(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select ID,
        CASE WHEN DATERANGETYPECODE=0 THEN 'All dates' WHEN DATERANGETYPECODE=1 THEN 'Specific dates' ELSE dbo.UFN_BILLINGITEM_GETACADEMICYEARBYDATES(STARTDATE, ENDDATE) END AS VALIDFOR,
        STARTDATE,
        ENDDATE,
        PRICE,
        dbo.UFN_BILLINGITEM_FLATRATE_COSTHISTORY_RECORDCOUNT(@CONTEXTID) AS RECORDCOUNT
    from dbo.BILLINGITEMPRICE        
    where BILLINGITEMID = @CONTEXTID
    order by STARTDATE DESC