title: How to select all columns where a set of them are distinct in SQL Server 2008 r2
body: <p>I have a bunch of columns in a sql table and I want insert every field of that table into a temp table where a set of the columns are distinct.  In other words, say I have a table with columns a, b, c, d, e, f, and g.  How could I select every row where a, b, and c are distinct?  </p>