rownum

I love the Over Partition:

row_number() OVER ( Partition BY <foreignkey, varchar> order by <foreignkey,varchar> ) AS [Seq]

Ctrl-Shit-M to populate