ramrajan (9/4/2015)
declare @startdate datetime = '2015-03-31 23:59:59.097';declare @enddate datetime = '2015-04-01 00:00:00.000';
returns 2
Awesome simplified solution with SELECT DATEDIFF(Year, @startdate, @enddate) + 1 AS QUARTER_DIFFERENCE
Correction Year should be replaceed with Quarter Keyword
SELECT DATEDIFF(quarter, @startdate, @enddate) + 1 AS QUARTER_DIFFERENCE