<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rssdatehelper="urn:rssdatehelper"><channel><title>The Farber Consulting Group Inc. comment feed for Remove duplicate records in sql</title><link>http://www.dfarber.com</link><pubDate></pubDate><generator>umbraco</generator><description></description><language>en</language><item><title>
          Re Remove duplicate records in sql by nishant pudota</title><link>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-30</link><pubDate>Thu, 29 Mar 2012 06:36:37 GMT</pubDate><guid>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-30</guid><content:encoded><![CDATA[ Thank you, looks good]]></content:encoded></item><item><title>
          Re Remove duplicate records in sql by Vishal Vivek</title><link>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-21</link><pubDate>Wed, 28 Dec 2011 12:18:10 GMT</pubDate><guid>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-21</guid><content:encoded><![CDATA[ That’s a great idea to remove duplicate records and I always look for a good source for my CRM data cleansing.]]></content:encoded></item><item><title>
          Re Remove duplicate records in sql by Gabriel Weinstein</title><link>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-20</link><pubDate>Wed, 28 Dec 2011 10:25:28 GMT</pubDate><guid>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-20</guid><content:encoded><![CDATA[ That's an interesting idea how you merged data from different fields and remove duplicate records.]]></content:encoded></item><item><title>
          Re Remove duplicate records in sql by tony Basir</title><link>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-22</link><pubDate>Mon, 02 Jan 2012 19:41:30 GMT</pubDate><guid>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-22</guid><content:encoded><![CDATA[ This is a problem that I have struggled with over time and created more than one solution for in various languages.  You solution to use the RowNumber and Partition clauses of SQL Server is a straight forward, easy to understand and implement.<br/>
Thanks for the copous examples and detailed notes.  I will be starting a cleansing project soon and this will save me a lot of time and agony]]></content:encoded></item><item><title>
          Re Remove duplicate records in sql by Jeffrey Peltz</title><link>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-23</link><pubDate>Tue, 10 Jan 2012 15:01:29 GMT</pubDate><guid>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-23</guid><content:encoded><![CDATA[ Hi,<br/>
<br/>
That’s a great idea to remove duplicate records while merging data from different records. I will definitely keep you in mind for any new data cleansing that I may need.<br/>
<br/>
Thanks,<br/>
<br/>
Jeff<br/>
]]></content:encoded></item></channel></rss>