SQL Comma Split Function for nth Loop

Question

I have a dynamic integer variable where the number of samples is loaded dynamically.

iCount = 3 
or iCount = 10  ( dynamically number is loaded ).

I have to split the number as 1,2,3 for the iCount = 3
1,2,3,4,5,6,7,8,9,10 for the iCount = 10
and 1 for the iCount = 1.

How can we achieve separation of functions through the nth variable in SQL?

Answer 1

DECLARE @iCount int = 10, @iCountRef varchar(100)

;WITH cte AS (
SELECT 1 as i
UNION ALL
SELECT i+1
FROM cte
WHERE i < @iCount
)

SELECT @iCountRef = STUFF((
SELECT ',' + CAST(i as nvarchar(10))
FROM cte
FOR XML PATH('')),1,1,'')

SELECT @iCountRef

Conclusion for 3:

1,2,3

Conclusion for 1:

1

Output for 10:

1,2,3,4,5,6,7,8,9,10

Answer 2

Simple version

DECLARE @iCount int = 10, @iCountRef varchar(100);


WITH CTE AS (
SELECT 1 as i, CAST('1' AS VARCHAR(8000)) AS S
UNION ALL
SELECT i+1, CAST(CONCAT(S, ',', i+1) AS VARCHAR(8000))
FROM cte
WHERE i < @iCount
)
SELECT @iCountRef =  S
FROM cte
Where i = @iCount;

SELECT @iCountRef