• I just realized that the ROW_NUMBER() function is included in the loading script, which will not work in 2K5. This would work instead:

    SELECT(TensValue * 10) + UnitsValue

    FROM(SELECT DISTINCT colid AS TensValue FROM sys.syscolumns

    WHERE colid BETWEEN 0 AND 9) b

    CROSS JOIN (SELECT DISTINCT colid AS UnitsValue FROM sys.syscolumns

    WHERE colid BETWEEN 1 AND 10) e

    ORDER BY (TensValue * 10) + UnitsValue