Viewing 15 posts - 736 through 750 (of 1,082 total)
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 8, 2008 at 2:37 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 10:37 am
Hi Jack,
Here is a spreadsheet, let me know if you come see anything...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 9:35 am
Whats the best way to post that on in here?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 9:30 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 9:08 am
Chris,,,
You making me nervious...
are you following me around today :w00t:
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 8:24 am
YIP I think a left join will work here
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 7:37 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 6:45 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 6:21 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 6:19 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 5:54 am
What is the Difference between MCP nad MCTIP?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 5:18 am
Thanks for that I'll have a look through them 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 7, 2008 at 5:06 am
Hi raym,
Just got you internal message now.
I would also go with Lynn's answer on this one.
Sorry for the delay 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 6, 2008 at 10:51 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 6, 2008 at 7:54 am
Viewing 15 posts - 736 through 750 (of 1,082 total)