<div>
ALTER your temp table to add an identity column 'i'<br />
<br />
delete from #tempTable<br />
WHERE i NOT IN (SELECT MAX(i) FROM #tempTable GROUP BY (item + customer) )
</div>


ALTER your temp table to add an identity column 'i'

delete from #tempTable
WHERE i NOT IN (SELECT MAX(i) FROM #tempTable GROUP BY (item + customer) )

<div>
Very neat!<br />
<br />
Now do I give the temporary table an identity column?<br />
<br />
this is what my temporary table looks like:<br />
&nbsp;CREATE TABLE #tempfile ( cus varchar(4), item varchar(4) , price smallmoney) 
</div>


Very neat!

Now do I give the temporary table an identity column?

this is what my temporary table looks like:
 CREATE TABLE #tempfile ( cus varchar(4), item varchar(4) , price smallmoney)

<div>
<div class="content wysiwyg-content">
I have a table with three fields:<br />
<br />
Item &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; varchar(4)<br />
Customer &nbsp;varchar(4)<br />
price &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; smallmoney<br />
<br />
<br />
sometimes there are more than one matching record. A matching record is when (item + customer) is the same.<br />
<br />
Is there a way to eliminate all the duplicates besides for the last one. The last one would be the one that was added to the table last. This table is a temporary table with no indexes. 
</div>
</div>


I have a table with three fields:

Item	  varchar(4)
Customer  varchar(4)
price	  smallmoney


sometimes there are more than one matching record. A matching record is when (item + customer) is the same.

Is there a way to eliminate all the duplicates besides for the last one. The last one would be the one that was added to the table last. This table is a temporary table with no indexes. 

Purging duplicate records?

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.