Hello All, Here are my statistics for each one...... Jonathan Roberts - ================(30 row(s) affected)Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahe

Jacob, A small error in View Source of sample script.... In 1st line the "lmu92" and "xaloc" are separated with comma "," instead of "/". -Pragnesh

@dishdy, Can you insert below record and test the statistics... Insert into TC35_Sessions VALUES( 'Pinal', 'TSQL', '2009-05-22 13:00 TCA' ) My solution fails to show this record with 0 count, I tweak my logic and numbers are horrible. Need to work

@dishdy Here are my new numbers.... I am trying to get more optimize in weekends :) (3 row(s) affected)Table 'TC35_TimeZones'. Scan count 4, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead

[quote user="dishdy"] .... Just put the following data in the right order: ;-) 2 Flemming login 2010-05-20 18:00 TCP2 Flemming logout 2010-05-20 18:25 TCP2 Flemming login 2010-05-20 18:30 TCA2 Flemming logout 2010-05-

@dishdy, below are the statistics for my solution #2 on same machine. (3 row(s) affected)Table 'TC35_TimeZones'. Scan count 4, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.Table

@dishdy Mike has a valid question.... Take an example of below SELECT 1, 'Jones', 'login','2010-05-20 14:13 TCI'UNION ALLSELECT 1,'Jones', 'logout','2010-05-20 14:13 TCI' SELECT 1, 'Jones', 'login','2010-05-20 14:13 TCI' UNION ALL SELECT 1,'Jones

Hi dishdy / Jonthan Here are my numbers.. I guess dishdy have my processor and ram details.. :) Dishdy.. your statistical comparison table for last challenge inspired all to optimize their solutions... Thanks for your valuable efforts... (3 row(s) af