Tim Chapman discusses your iteration choices in SQL Server 2008 and ... This type of operation is very tricky to do in situations where your underlying base table does not have a primary key ...