SQl query for repeat rows

WITH E1 (N) AS 
(
    -- 1*10^1 or 10 rows
    SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
),
E2 (N) AS 
(
    -- 1*10^2 or 100 rows
    SELECT 1 
    FROM E1 a, E1 b
),
E4 (N) AS 
(
    -- 1*10^4 or 10000 rows
    SELECT 1 
    FROM E2 a, E2 b
),
Tally (N) AS
(
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
    FROM E4
)
SELECT
    D.Name,
    D.Telugu,
    D.Image,
    D.price
FROM
    YourTable As D
    INNER JOIN Tally As T
    ON T.N <= D.quan
ORDER BY
    D.Name
;

create table #InputData (col1 varchar(100), col2 int);
insert into #InputData values('jack1 ౮౦౦ 4698ee8-.gif 920', 25);
insert into #InputData values('jeans30-32 ౬౦౦ 47d975c-.gif 690', 50);
insert into #InputData values('tshirt35 ౩౫౦ 9df27e4-.gif 402.5', 35);
insert into #InputData values('jaen123 ౭౦౦ bcb6a0b-.gif 805', 23);

Declare RestCursor cursor for select col1, col2 from #InputData;
Declare @Col1 varchaR(100);
Declare @Col2 int;
Declare @Count int;

create table #ResultTable (col varchar(100));
open RestCursor;
fetch next from RestCursor into @Col1, @Col2;

while @@FETCH_STATUS = 0 begin
    set @Count = 0;
    while @Count < @Col2 begin
        insert into #ResultTable values(@Col1);
        set @Count = @Count + 1;
    end;
    fetch next from RestCursor into @Col1, @Col2;
end;
close RestCursor;
deallocate RestCursor;

select * from #ResultTable;

drop table #ResultTable;
drop table #InputData;