cust_id trans_dt a0001 12/05/2005 a0002 12/05/2005 a0001 12/05/2005The table does not have a ROWID or identifier field. I would like to delete the duplicate records and have the results formatted like this:
a0001 12/05/2005 a0002 12/05/2005 -----------------------In Oracle there is ROWID to solve this problem. Is there a way to resolve this in SQL Server?
- SELECT DISTINCT cust_id, trans_dt INTO temp_tbl FROM customertrans
- TRUNCATE TABLE customertrans
- INSERT INTO customertrans SELECT * FROM temp_tbl
Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in October 2005