Viewing 4 posts - 1 through 4 (of 4 total)
Sorry I didn't take enough time to understand your question.
One more shot at it. How about two step query?
Insert in temp table all your records using "select rank=count(*), entry_id,...
February 8, 2005 at 8:27 am
A quick idea based on all the time values being [minutes:seconds]. Store the time as a whole number. 1:35 becomes 135. Now you order (rank) using it.
For display convert...
February 8, 2005 at 8:08 am
Hello Antares686,
Thanks for your quick and valuable response. We didn't realize a failed insert could still increment an identity counter.
That was the clue we needed. Found the problem, an unexpected...
January 7, 2005 at 11:42 am
Thanks for the suggestions.
We have set formatting and language correctly.
Just to confirm, we are running server side VBScript scripts.
I should have posted snippets of the code...
January 21, 2004 at 9:29 am
Viewing 4 posts - 1 through 4 (of 4 total)