Home Forums SQL Server 2008 SQL Server 2008 - General Insert duplicate rows based on number in the column RE: Insert duplicate rows based on number in the column

  • March 21, 2013 at 10:27 am

    #1599472

    knakka 14475 (3/21/2013)

    Hi ChrisM@Work thank you for the reply.. I have one question in case they are more than 100 quanties what do I need to do.

    ;WITH

    -- Make an inline tally table (CTE)

    E1(N) AS (

    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

    ), --10E+1 or 10 rows

    E2(N) AS (SELECT 1 FROM E1 a, E1 b), --10E+2 or 100 rows

    Tally(N) AS (SELECT 1 FROM E2 a, E2 b)

    SELECT COUNT(*) FROM Tally

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden