If we are using ar eport parameter which is duplicate values. you can remove duplicate records by using T-SQL DISTINCT function in the SELECT query or stored procedure. If dataset has manual entry for available values then check the list of available values and remove the duplicate value. If Source is excel or other file system then remove the duplicacy there itself.
--TSQL statement to pull distinct records from table
SELECT DISTINCT NAME FROM TABLE
No comments:
Post a Comment