DECLARE @SQL nvarchar(max) =
N'
DECLARE @T AS table (c1 integer NOT NULL);
WITH CTE (c1) AS
(
SELECT V.v
FROM
(
VALUES
!list!
) AS V(v)
)
INSERT @T (c1)
SELECT c1
FROM CTE;
';
SET @SQL =
REPLACE
(
@SQL,
N'!list!',
(
SELECT
STRING_AGG
(
CONVERT
(
nvarchar(max),
CONCAT(N'(', GS.[value], N')')