Copy As IN Clause Duplicates

Dave Pendleton

I swear I remember that the "Copy As IN Clause" option in a grid removed duplicates. However now when I use it, duplicates are included. Is this correct?

SMSS 19.1
SQL Prompt 10.13.16.3650

Ben_P

Hi Dave,

Thank you for your post. Copy As In Clause should remove duplicates you're right:



I am running the same version of SQL Prompt, and it appears to remove the duplicates. 

If you can try exporting a copy of your SQL Prompt settings (SQL Prompt>Options>Export) and then restore the options to the default. Then save and close SSMS and re-open and try the Copy As In Clause option again. Does this change the behaviour? If not, then you can restore your previous settings by importing the settings file that you previously exported.