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.

• Next in forum: Class does not support aggregation
• Prev in forum: Re: Why does SQL2005 automatically insert TOP 100 PERCENT in views?
• Thread view: Re: one for the SQL experts - dare I say TRICKY SQL!

[Reply to this message]