Alpha Sort Group Types

BEGIN TRANSACTION AlphaSortGroupTypeOrder

UPDATE dbo.GroupType
SET [Order] = Alpha.AlphaOrder
FROM dbo.GroupType GT
JOIN (
    SELECT
    [Id],
    ROW_NUMBER() OVER(ORDER BY GT.[name] ASC) AS AlphaOrder,
    [Name]
    FROM GroupType GT
    ) Alpha ON Alpha.[Id] = GT.[Id]

COMMIT TRANSACTION AlphaSortGroupTypeOrder