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.

• Next in forum: Re: Track the changes to normalised tables and update the denormalised tables depending on the changes to normalised tables
• Prev in forum: Re: Import multiple .DBF files w/SSIS - OLE DB
• Thread view: Re: 'Select top 10 * ...' returns data but 'Select * ..' does not

[Reply to this message]