<div>
you could do the following:<br />
<br />
1) Select all distinct rows into a new table<br />
2) truncate your original table<br />
3) copy rows from the table you created into the original table<br />
<br />

<pre><code id="code-20-41816877-1">SELECT DISTINCT col1,col2,col3
INTO   #staging
FROM   Table1

TRUNCATE TABLE Table1

INSERT INTO Table1 (col1,col2,col3)
SELECT col1,col2,col3
FROM #staging</code></pre>
</div>


you could do the following:

1) Select all distinct rows into a new table
2) truncate your original table
3) copy rows from the table you created into the original table



SELECT DISTINCT col1,col2,col3
INTO   #staging
FROM   Table1

TRUNCATE TABLE Table1

INSERT INTO Table1 (col1,col2,col3)
SELECT col1,col2,col3
FROM #staging

<div>
you could also create a new regular table with the same structure, insert distinct data in that table, then delete your original table and rename new table to the same name as original table had
</div>


you could also create a new regular table with the same structure, insert distinct data in that table, then delete your original table and rename new table to the same name as original table had

<div>
<div class="content wysiwyg-content">
I have 7 columns.<br />
i need rows to be deleted if there is a duplicate if all cells match between two rows on all 7 values.<br />
is there an easy to do this?
</div>
</div>


I have 7 columns.
i need rows to be deleted if there is a duplicate if all cells match between two rows on all 7 values.
is there an easy to do this?

deleting duplicates in a sql table

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.