Hello Dani Webbers,
So I've been given this old-as-hell database, it was designed in 1993 under pick, and it isn't at all normalized, in a good effort I've migrated all the data into MSSQL 2008 server and I have some several to several relations between tables, on of these relations are composed by two foreign keys, the keys are OK, but in some cases there are rows repeated.
Can you please suggest a way to delete one row, and keep the other one in the same table?
Thanks
Backup the db before you try this. You'll also need to add a unique ID column if there's not one already.
DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3)http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.