Replicate multiple times a set of rows with unique column in a table
WITH gen AS (
    SELECT 1 AS num
    UNION ALL
    SELECT num+1 FROM gen WHERE num+1&lt;=5
)
INSERT INTO test1 (name,value,type)
SELECT 'ins_' + CONVERT(varchar,num) + '_'  + CONVERT(varchar,id), value, type 
FROM gen
CROSS JOIN test1

Some explanation provided by the OP, added so others can adapt the solution:

Actually used CTE as a generator of integers (called
'fnTally') which he later used in CROSS JOIN to produce cartesian
product of those two tables - the source one which is 'test1' and
generated by CTE called 'gen' (a combination of every row from two
tables). The only further optimization here would be to use cCTE
(cascade CTE introduced by Itzik Ben-Gan).