Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Feb 07, 2008 05:45 AM|LINK
> 1. while adding data to teamtable and teamemtable, the duplication of data is also accepting.
any idea how to remove the duplication?
If have TSQL returning duplicate values, you can use DISTINCT to remove duplicate values as in:
SELECT DISTINCT A, B FROM FRED .........