List quarters from/to in year-range

Quarters.sql

DECLARE @in_yearFrom int
DECLARE @in_yearTo int 
DECLARE @in_QuartalFrom int
DECLARE @in_QuartalTo int 

SET @in_yearFrom = 1800
SET @in_yearTo = 1805
SET @in_QuartalFrom = 2
SET @in_QuartalTo = 3

;WITH CTE AS 
(
	SELECT 
		 1 AS q
		,@in_yearFrom AS y
		,DATEADD(year, @in_yearFrom - 1900, CAST(0 AS datetime)) AS s 
		,DATEADD(month, 3, DATEADD(year, @in_yearFrom - 1900, CAST(0 AS datetime))) -1 AS e
		
	UNION ALL 
	
	SELECT 
		 (CTE.q%4) + 1 AS q 
		,YEAR(DATEADD(month, 3, CTE.s)) AS y 
		,DATEADD(month, 3, CTE.s) AS s 
		,DATEADD(month, 3, DATEADD(month, 3, CTE.s)) -1 AS e 
	FROM CTE 
	
	WHERE DATEADD(month, 3, CTE.s) < DATEADD(year, 1 + @in_yearTo - 1900, CAST(0 AS datetime)) 
)

SELECT * FROM CTE 
WHERE (1=1) 
AND s >= DATEADD(month, (@in_QuartalFrom-1) * 3, DATEADD(year, @in_yearFrom - 1900, CAST(0 AS datetime))) 
AND s <= DATEADD(month, (@in_QuartalTo-1) * 3, DATEADD(year, @in_yearTo - 1900, CAST(0 AS datetime)))