Without using a cursor,
given a table with time values:
START END
12:30 13:00
13:30 14:00
14:00 14:30
15:00 15:30
Is there an SQL way to return the empty slots:
13:00 13:30
14:30 15:00
I'm thinking a view that starts with row 2
joined with the table and sprinkled with a function
or two. Something weird like that!
Any hopes?
Chuck Lockwood
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LockData Technologies, Inc.
309 Main Avenue, Hawley, Pa 18428
Phone: 570-226-7340 ~ Fax: 570-226-7341
Email: [EMAIL PROTECTED] ~ http://www.lockdata.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
