Reply to Re: one for the SQL experts - dare I say TRICKY SQL!
Posted by paulspratley on 02/07/06 18:40
There are 2 occassions when the user count is 1 at the start of
Threadid 1 and when the last thread 4 is kicked off. Threadid has 2 *
10 (measurements) = 20 and Threadid 4 has 2 * 40 (measurements).
Therefore 100 measurements in total. Two threads therefore average =
50.