Posted by paddymullaney on 12/07/06 14:50

The problem lay in a join to another database on a datatype of
sqlvariant.

BOL shows how the sql_variant comparison rules work. I needed to bypass
these for data in rows after my top 10 list provided.


I had to use openquery and cast the datatype first to get a join.

[Back to original message]