In this post, I am sharing a script to copy a unique record from one table to another. You can perform this activity using ROW_NUMBER() and PARTITION BY clause. This partition clause identified set of duplicate records and row_number assign an ID for this set. Below is a full demonstration: Let’s first create table with … Continue reading Copy unique records from one table to another in SQL Server