﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged T-SQL, ranking</title><link>http://www.sqlservercentral.com/</link><description>Content tagged T-SQL, ranking posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Using Ranking Functions to Deduplicate Data</title><description><![CDATA[<p>This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005 </p><!-- safeguard (SQL Backup) -->
<table border="0" cellpadding="0" cellspacing="10" style="width: 100%;"> <colgroup>  <col width="68" />  <col width="1266" /> </colgroup> <tbody>  <tr align="left" valign="top">   <td>    <a href="https://sqlbackup.red-gate.com/LogIn?utm_source=ssc&utm_medium=pubad&utm_content=safeguard_backups&utm_campaign=sqlbackup&utm_term=rss-20016"><img src="http://assets.red-gate.com/external/SSC/backuphosted_white_68x68.png" alt="sqlbackup"></td>   <td><strong>New! Safeguard your SQL backups</strong><br />Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate.  <a href="https://sqlbackup.red-gate.com/LogIn?utm_source=ssc&utm_medium=pubad&utm_content=safeguard_backups&utm_campaign=sqlbackup&utm_term=rss-20016">Learn more</a></td>  </tr> </tbody></table>

]]></description><guid>http://www.sqlservercentral.com/articles/Deduplicate/70499/</guid><pubDate>Tue, 27 Jul 2010 06:00:00 UT</pubDate><link>http://www.sqlservercentral.com/articles/Deduplicate/70499/</link></item></channel></rss>