For the data listed there, what should the results be?
Also, any chance you can post create table statements and the sample data as inserts (easier to use)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability