Based on Azure sql columns populate row of record to insert into a sub table

[harishgg1]

small correction

;WITH tally_cte
     AS (SELECT TOP 100 Row_number()
                          OVER (
                            ORDER BY (SELECT NULL)) AS rn
         FROM   sys.all_columns a
                CROSS JOIN sys.all_columns b)
SELECT 'SQL Output ', 
b.id,
       1
FROM   tally_cte a
       JOIN @tbl1 b
         ON a.rn <= b.qty
ORDER  BY b.id,
          a.rn