Use the new ROW_NUMBER() feature in 2005.
select *,
Row_number() over (PARTITION BY PersonID)
From
tblPerson
Partition by works like a group by (it's what resets the count)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?