Snippets of the day – Friday, October 11, 2013

Posted on Posted in Snippets

code-snippet

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 and parse a txt file in python

This code shows how to read a txt file and parse the data

Open the snippet

Author:    lbottaro

Leave a Reply

Your email address will not be published. Required fields are marked *