Program to display text 'N'th time using a recursive CTE in SQL Server

DECLARE @N INT  = 10

;With Cte AS
( 
	SELECT 
			1 AS rn,
			'Hello World' AS [Text]

	UNION ALL

	SELECT 
			rn+1, 
			'Hello World' AS [Text] 
	FROM Cte 
	WHERE rn<@N
)
 
SELECT 
	[Text] 
FROM Cte 
OPTION (MAXRECURSION 0)

In the above program we are using a recursive CTE that will execute till the condition is true and finally prints the result

/* Result

Text
-----
Hello World
Hello World
Hello World
Hello World
Hello World
Hello World
Hello World
Hello World
Hello World
Hello World

*/