Home Forums SQL Server 2012 SQL Server 2012 - T-SQL T-SQL to Forecast value till the end of the year RE: T-SQL to Forecast value till the end of the year

  • October 31, 2014 at 1:42 pm

    #1756144

    Here is another alternative..

    select TheDate

    ,TheMonth

    ,WeekName

    ,ParcelCount2013

    ,case when TheDate is not null and TheDate > '2014-10-02' and TheDate < '2015-01-01' then ParcelCount2013 + ((ParcelCount2013 * 5)/100) else ParcelCount2014 end as Parcel_Count_2014

    from d