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))