December 30, 2010 at 3:43 pm
Good for you, Robert, and thanks for letting us know that you have a solution now. Good luck to you in the coming year.
One comment on your solution for future readers. It requires you to scan your primary table from start to finish TWICE, which could add up to a lot of work if you were doing this to a table with millions of rows. ( I don't believe that is the case here.) The advantage of adding a temporary table was that it would read the main table one time and produce a smaller table for the second scan needed to produce the counts.
Happy New Year, guys !!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 30, 2010 at 3:56 pm
The Dixie Flatline (12/30/2010)
Good for you, Robert, and thanks for letting us know that you have a solution now. Good luck to you in the coming year.Happy New Year, Lutz!
Same to you Bob!
May the year be busy enough to cover your bills but leaving enough time for your family and a post or two!!
January 4, 2011 at 6:32 am
LutzM (12/30/2010)
The Dixie Flatline (12/30/2010)
Good for you, Robert, and thanks for letting us know that you have a solution now. Good luck to you in the coming year.Happy New Year, Lutz!
Same to you Bob!
May the year be busy enough to cover your bills but leaving enough time for your family and a post or two!!
What a great blessing for the New Year. Same to you, Lutz !! 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply