Home Forums SQL Server 7,2000 T-SQL Arrays RE: Arrays

  • August 17, 2008 at 6:53 pm

    #859220

    You can get by without creating the extra temp table...

    SELECT d.Name,t.N*10 AS DeciCount

    FROM (SELECT Name,COUNT(*) AS TheCount

    FROM #Name

    GROUP BY Name) d

    INNER JOIN dbo.Tally t

    ON t.N <= d.TheCount

    GoFigureFW... if you don't know what a Tally table is, please see the following link...

    http://www.sqlservercentral.com/articles/TSQL/62867/

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)