How can I update all rows in a Table and increment a field?
===

I have a table in a Microsoft SQL 2008 database.  I need to update a particular columns value but increment it's value at the same time.  To explain:

If the Table is :

    CREATE TABLE [dbo].[Player]
    (
    	[PlayerID] [uniqueidentifier] NOT NULL,
    	[UnitID] [uniqueidentifier] NULL,
    	[ExerciseID] [uniqueidentifier] NOT NULL,
    	[Designation] [nvarchar](256) NOT NULL
    )

I want to go through every row which has an ExerciseID of `42C45D73-3FE6-4AFA-8E2F-09BDFC6CBDF7`
and Update the Designation to be "Player - X" but X should start at 0 and increment itself by one every time.  So the first player to be updated would be "Player - 1" the second would be "Player - 2" and so on.

I have no idea where to start with something like this!

Thanks