Today I need to compare the data accuracy between 2 tables in SQL Server 2008 R2. There is one interesting scenario of Fiscal Year and Quarter for me to validate. The first quarter of a fiscal year starts on October 1 every year.
Q4 (FY 2013): July –September, 2013
Q1 (FY 2014): October -December, 2013
Q2 (FY2014): January –March, 2014
Q3 (FY2014): April –June, 2014
Q4 (FY2014): July –September, 2014
Actually, we can use datapart and case when in SQL query easily.
After that, here is the expected result.