1. Can a challenge have NULL winners.. ( ie for example challenges that have not yet been evaluated ) , ie the Winners field contains the value NULL. ? 2, When a star is split between 2 or more winners, will there always be names to the left and right o

@Dishdy If you get the same results when adding the above data, well then there is something wrong as attendee 5 clearly has an hour of time added which puts him smack in the session 2.. So results are different :) SELECT 5,'Eric', 'login','2010-0

@Dishdy I have a Intel Core Duo 1.97GGHZ clockspeed with 2gb RAM Table 'TC35_TimeZones'. Scan count 19, logical reads 19, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'TC35_Sessions'.

AH lol ok ..yep.. that would explain it let me recalculate

Hi dishdy , well thats what i meant with last logout will be the end of the event. Maybe just phrased it odd, but yeswe are to assume he stayed logged in until the end of the entire event ( ie last session endtime ). I cannot see what other assumption ca

OK, so according to the rules each login record with have a logout record except the last login record , which may not have a logout record.IF there is not logout time, we are to assume last logout will be end of the event IN the case of Jones for example