SQL Puzzle 10: Print a Right-Angled Triangle from a Word

Given a word (e.g., 'FABRICOFDATA'), write a SQL query to output each row of a right-angled triangle, where each row displays the first N characters of the word

Expected Output:

Tap For Closer Look

Try solving the question yourself! If you need help, click below to reveal the solution.

--------DESIGN TRIANGLE FROM YOUR NAME------------

DECLARE @P VARCHAR(250)='FABRICOFDATA'

 DECLARE @P_BEGIN int=1
 DECLARE @P_END int=1
 DECLARE @T VARCHAR(250)=NULL

 WHILE @P_BEGIN  <=LEN(@P)
 BEGIN

     SET @T=IIF(@T IS NULL,'',@T)+SUBSTRING(@P,1,@P_BEGIN)+CHAR(13)+CHAR(10)
	 SET @P_BEGIN=@P_BEGIN+1
END
PRINT(@T)