Reseeding identity insert in MS SQL useful when The table has foreign key constraints and can not be truncated
posted in MS SQL Server by shyam
Selecting the latest records from the sets of redundant records in MS SQL. This query can be adopted and adapted to other databases