0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Posted Topic
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 and then SET ROWCOUNT 1 DELETE FROM table WHERE fid = 1 AND fid = 1
The End.