What I'm trying to get at is this: Is there another way of doing this search?
All the NOT LIKE and NOT IN clauses are going to kill performance. Think...

(Maybe I should have read more carefully!)
Those NOT LIKE and <> s are going to cause table scans. Performance will be brutal.

I'm probably going to get grief for saying this, but have you considered creating a view containing the filters you always use and then querying that? I freely admit that...

Before I suggest anything, I'd like to be sure I know the problem. There's a really good article on Subclassing by Rebecca Riordan (but she's implementing it in Access -...

Okay.
SSIS just baffles me. How much RAM am I supposed to have for this? If I open a Script task, it takes like 15+ seconds to close again. WTH???!!!...

Oh, okay. I'll give it a try. (Remember when MSFT used to be really explicit about which version of a program was installed and you could go to help>about and...

Do I seriously have to create a DSN for this to work?

Thanks Federico. I downloaded that and installed it,
I created a connection using the Source Assistant and could only connect to the database at all using the SSIS provider. But...

Please post the table definitions for the relevant tables. What you're doing sounds way harder than this should be.

Isn't it as simple as DIVIDE(COUNTROWS('OrderLineItems'),COUNTROWS('Orders')) ?

This?
SELECT SortOrder, country, colour, amount
    , DENSE_RANK() OVER (ORDER BY SortOrder) AS rn
FROM #testing
ORDER BY SortOrder
        , Country
        , Colour
        , Amount

Oh wait,...