Copy As IN Clause

From a results grid in SSMS, highlight one column of values, right-click on the grid, and use SQL Prompt's Copy as IN clause tool to reformat the values as an IN clause, which you can then use to, for example, query another table, comparing the rows for differences.

Didn't find what you were looking for?