DECLARE @Year DATE = '2013-01-01'
DECLARE @Quarter INT = 4;
SELECT DATEADD(QUARTER, @Quarter - 1, @Year) ,
DATEADD(DAY, -1, DATEADD(QUARTER, @Quarter, @Year))
DECLARE @Year DATE = '2013-01-01'
DECLARE @Quarter INT = 4;
SELECT DATEADD(QUARTER, @Quarter - 1, @Year) ,
DATEADD(DAY, -1, DATEADD(QUARTER, @Quarter, @Year))