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
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