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. Open the snippet Author:    cghersi How to read […]