ok, that's not what I thought you meant. I thought you meant flip all the bits.

This works for 0 and 1:

DECLARE @smallint smallint = 0
select...

What are the datatypes for the two columns in Question #1?

Probably so he can get away from having to run two separate queries and then merge the results with a distinct UNION.  That may or may not be faster, though. ...

I would...

Perhaps more important than the DISTINCT keyword is the AVG() function's handling of NULL values.

NULLs behave similarly to DISTINCT - regardless of how AVG() is called. That is, the...

Heh... there is an EXCEPT, though... same "class" of method.

Just in case you're still around, the reason I'm asking is because, if the ultimate use is to import the data into another SQL Server, using BCP Out in the...

In other words, please read and heed the article at the first link in my signature line below for one of many methods to provide some "Readily Consumable Test Data"...

Please go back and read the reply from Scott Pletcher and myself.

I agree that it sounds like you're trying to do a server to server transfer.  With the exception of...

It might be possible but I'm not going through the code to figure out which columns are coming from which tables.  Using table aliases in all columns when joins are...

Thanks for the feedback on what it turned out to be, Jonas.

What did you end up doing?  I know this would help others in the future.

Here's the query to cover your first request.

 SELECT  MontaguOwner                ...

Hi Jeff,

Using the same test data I provided I wonder if you could help me build on your code to achieve an additional outcome.

So, on the test data, I...

See my post on the other thread.  I've also just updated...