<div>
Hi Ste5an. That looks good, I am using SQL 2008
</div>


Hi Ste5an. That looks good, I am using SQL 2008

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
In my VB.net project I pull the data shown below into &nbsp;a DataGridView using the following SQL statement.<br />
It shows all records with the same Article and &nbsp;Site combination. How do I delete all duplicates leaving one record<br />
containing the combination<br />
<br />
select rtrim([Article])+rtrim([Si<wbr />te]),count<wbr />(*) As Count_Duplicates from [MARC] group by rtrim([Article])+rtrim([Si<wbr />te]) having count(*)&gt;1<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/12_w52/889680/Image1.jpg" target="_blank" title="1 (20 KB)"><img alt="1" class="file-block lazyload" style="max-width: 241px;" data-src="https://filedb.experts-exchange.com/incoming/2014/12_w52/889680/Image1.jpg" /></a>
</div>
</div>


Image1.jpg

Hi

In my VB.net project I pull the data shown below into  a DataGridView using the following SQL statement.
It shows all records with the same Article and  Site combination. How do I delete all duplicates leaving one record
containing the combination

select rtrim([Article])+rtrim([Site]),count(*) As Count_Duplicates from [MARC] group by rtrim([Article])+rtrim([Site]) having count(*)>1



VB.net SQL Deleting duplicates

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.