• I think you're looking for this (Please note how I adjusted your build to create the full test script):

    DECLARE @MyTable TABLE ( FirstCol VARCHAR(50), SecondCol INT)

    INSERT INTO @MyTable (FirstCol, SecondCol)

    VALUES ('Waverider',1);

    INSERT INTO @MyTable (FirstCol, SecondCol)

    VALUES ('Psalms',2);

    INSERT INTO @MyTable (FirstCol, SecondCol)

    VALUES ('WRV',3);

    INSERT INTO @MyTable (FirstCol, SecondCol)

    VALUES ('18th Street',3);

    INSERT INTO @MyTable (FirstCol, SecondCol)

    VALUES ('Soundside',3);

    Select

    FirstCol,

    SecondCol,

    ROW_NUMBER() OVER ( PARTITION BY SecondCol ORDER BY FirstCol) * 100 AS Incrementor

    From

    @MyTable

    ORDER BY

    SecondCol, FirstCol


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA