sharonsql2013 (6/26/2014)

---

I need to compare the ACC_Backlog data for the last two months. The table has monthwise data from May 2013 until May 2014. I am only looking for last two months comparision.

So, if ACC_Backlog of may 2014 is > april then it should display "1" or "Higher" else 0 or "lower"

Here is the existing query, Can anyone advise?

Select Month_Year

,datepart(month, cast(replace(Month_Year, '-', '') as datetime)) as MyMonth

, datepart(year, cast(replace(Month_Year, '-', '') as datetime)) as MyYear

,Group

,ACC_Opened

,ACC_Closed

,ACC_Backlog

,Time_Stamp

from ACC_ByMonth

WHERE Group = 'Investments'

--ORDER By MyYear desc , MyMonth desc