NPS sybase query to fetch details
we have sql as DB in our NPS reporter, we do see a duplicate value exists in the same name from the report.
So we would like to delete the duplicate values from the sybase, Please share the commands that can be used to view and delete the duplicate/invalid entries from the table. also what are the default tables created for the NPS, any documents specific to this queries available?
Re: NPS sybase query to fetch details
Look into the create index command's IGNORE_DUP_ROW option. It shuld give you what you're looking for.