Convert Rows To Column with Factorial Sr.Number in SQL

Hi,

Please refer below Sql Script

SQL

DECLARE @Temp AS TABLE(Name VARCHAR(20),[Address] VARCHAR(20),email VARCHAR(20))

INSERT INTO @Temp VALUES('AAA','BBBB','CCCC')
INSERT INTO @Temp VALUES('XXX','YYY','ZZZZ')

SELECT * FROM @Temp

DECLARE @t as TABLE([Sr.no] DECIMAL(18,1),Details VARCHAR(50))

DECLARE @i INT
SET @i = 1

DECLARE @RecordCount INT
SELECT @RecordCount = COUNT(*) FROM @Temp

WHILE @i <= @RecordCount
BEGIN	
	DECLARE @count DECIMAL(18,1)

	SET @count = @i

	INSERT INTO @t VALUES  
	(@i,(SELECT Name FROM 
	(
		SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 0)) as RowNumber,* FROM @Temp
	)as tbl
	WHERE tbl.RowNumber = @i))
	
	 SELECT @count = (@count + 0.1)

	INSERT INTO @t VALUES
	  
	(@count,(SELECT [Address] FROM 
	(
		SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 0)) as RowNumber,* FROM @Temp
	)as tbl
	WHERE tbl.RowNumber = @i))

	 SELECT @count = (@count + 0.1)
	INSERT INTO @t VALUES

	(@count,(SELECT email FROM 
	(
		SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 0)) as RowNumber,* FROM @Temp
	)as tbl
	WHERE tbl.RowNumber = @i))

	SET @i = @i +1
 
END

SELECT * FROM @t

Screenshot