In this context, the <> isn't really a problem. The issue with <> in joins is typically that you have to compare every record in the second table to the...

It sounds like you're doing an equivalent to SELECT * FROM MyTable ORDER BY PK OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY, followed by SELECT * FROM MyTable ORDER...

• This reply was modified 2 years, 6 months ago by  Kingfossil. Reason: fixed some typos
• This reply was modified 2 years, 6 months ago by  Kingfossil. Reason: even more typos

There was no candy listed for the USA. 'Merica!!

It isn't capitalism for companies to do something that suits them and not the customer.

Capitalism is where someone starts a company that DOES excite the customer, we all buy their...