SET @paramNames = LEFT(@paramNames, LEN(@paramNames) -  1 )

	SET @len = LEN(@paramNames)
	SET @len = CASE WHEN @len >  0  THEN @len -  1  ELSE  0  END
	SET @paramNames = LEFT(@paramNames, @len)

CREATE PROCEDURE [dbo].[hp_Test] 
AS
BEGIN
	SET NOCOUNT ON;
	
	DECLARE @paramNames nvarchar( 4000 ) = N''
	
	SELECT @paramNames = @paramNames + N'param' + CAST(n.number AS nvarchar( 4000 )) + N','
	FROM (
		SELECT DISTINCT sp.number 
		FROM master.dbo.spt_values sp 
		WHERE sp.number BETWEEN  0  AND  10 
	) n	

	SET @paramNames = LEFT(@paramNames, LEN(@paramNames) -  1 )
	
	/*
        DECLARE @len int = LEN(@paramNames)
	SET @len = CASE WHEN @len >= 1 THEN @len - 1 ELSE 0 END
	SET @paramNames = LEFT(@paramNames, @len)
	*/
		
	SELECT @paramNames AS paramNames
END