Forum: MS SQL May 19th, 2007 |
| Replies: 13 Views: 27,234 the simple method remove duplicate rows on the table using the following query
first find the rows which have duplicates
SELECT identity column(fid)
FROM table
GROUP BY fid
HAVING COUNT(*) > 1... |