Snippets of the day – Friday, October 11, 2013

Posted on Leave a commentPosted in Snippets

Here are some of the most recently published snippets! Removing Duplicated rows from table Let’s use ROW_NUMBER() to purge tables from duplicated data. You need to identify which set of columns are the unique key and then apply PARTITION over them. Thanks to Stefan Krzywicki. http://www.sqlservercentral.com/articles/duplicate+data/102383/ Open the snippet Author:    cghersi How to read […]