Thank you for the response.

I support both SQL 2005 (Express and Standard) and SQL 2000. So whatever I write has to work in both environments.

Thank you, that works.

Could you comment on the following query, which lists all the available slots?

select X.thisAppt, datediff(mi, X.thisAppt, X.nextAppt) gapTillNextAppt from

(select A1.endDateTime thisAppt, min(A2.apptDateTime) nextAppt from appts A1,...

eharper (and others): Thank you very much responding to me.

You are right about storing redundant data - in actuality I do not store the endDateTime, and both my table and...

http://www.sqlservercentral.com/Forums/Topic621231-338-1.aspx

Could you please help me understand the query you have written, I am tring to work on 'finding the next available time slot' in a scheduling application and can use...

Yes, that makes sense. Thanks again for your help.

Thank you very much for the response. I will try it out.

As to the reason for asking....a client has suggested that they suspect rows are mysteriously disappearing from a table.

Since...

I am trying this on SQL Svr 2000, SQL Express 2005 and SQL Express enterprise.....I have clients who use all three.

As to table structure:

CREATE TABLE [dbo].[appointments] (

[apptSeq] [int] IDENTITY (1,...

Thank you, that works, I would not have thought of it.

Thank you, this is brilliant, works perfectly.