Monthly Archives: October 2017

SQL Server delete the duplicate rows

This short blog basically a continue version of the blog SQL Server find the duplicate rows (https://chanmingman.wordpress.com/2017/09/23/sql-server-fine-the-duplicate-rows/). Once you find the duplicated row then you want to delete them. Before that, do store your unique row of your duplication rows … Continue reading

Posted in .Net, Community, Computers and Internet | Tagged , , | Leave a comment

SSIS find and remove the duplicate rows

This short blog shows you how to list the data in duplicated rows using. Let’s look at the Northwind (https://chanmingman.wordpress.com/2012/03/18/northwind-in-microsoft-sql-server-2012/) database in SQL Server. You can see the Shippers table has 2 duplicate rows, United Package. Duplicate the Shippers table. … Continue reading

Posted in .Net, Community, Computers and Internet | Tagged , , , | Leave a comment