> Is there an SQL way to return the empty slots: > 13:00 13:30 > 14:30 15:00
SELECT End, MIN(t3.Start) FROM YourTable t1, YourTable t3 WHERE NOT EXISTS (SELECT * FROM YourTable t2 WHERE t2.Start = t1.End) AND t3.Start > t1.End GROUP BY End _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
