You guys are my hero's 🙂

OK I update the stats on my tables and this little baby, is humming like a beauitful tropical bird 🙂

Ok so I guess this means...

Thanks Jack,

The strange thing is this.

In the fast sheet where you have indicated in yellow they are all scans.

In the slow sheet where you have indicated in yellos they are...

Hi Jack,

Here is a spreadsheet, let me know if you come see anything...

Whats the best way to post that on in here?

Thanks Jack,

Thats exactly what I thought.

Which is why I thought I would ask, but just so you know it's 10 times fast with the TOP clause in place.

I'll keep looking...

Chris,,,

You making me nervious...

are you following me around today :w00t:

YIP I think a left join will work here

ah Chris my bad,

I'm 2005, wierd that the results are different it must do with the Percent and Order by clause combination.

Ankur

n is basically a number, in the...

HI khadakrhan,

Good solution.

See if you can challenge yourself and make that code work with a tally table like the other two solutions.

RBAR is bad as you will learn more and...

HI Chris,

I copied your code straight into a a query window and here are the results I code

TheValue(No column name)

132132

873873

969969

HI Chris,

Your solution does not work.

The TOP 100 PERCENT is messing with your results.

If you make TOP 100000 then it works

Which is problem considering you don't know how many rows...

What is the Difference between MCP nad MCTIP?

Thanks for that I'll have a look through them 🙂

Hi raym,

Just got you internal message now.

I would also go with Lynn's answer on this one.

Sorry for the delay 🙂

Hi there,

No problem what so ever, and just so you know I tried this with a list of about 3000 and it still worked pretty fast.

The only thing I don't...