SELECT *, IncrementThisValueByOne FROM MyTable
MyFieldOne MyFieldTwo IncrementThisValueByOne Bobby Jones 1 Jamie Lee 2 Terry Hatcher 3