A BookingTBAQueue table. Seems to be doing what i need it too.

That's a great idea. I sort of had that theory in my head, but couldn't for the life of me think how to do it for looking too hard at...

And regarding the availabilities ending at 23:59, that was just an example to show someone was available for the whole day. People can set availability that run over several days...

That's great, it seems to work a treat.

What i might do for people that are unavailable, is run a separate query to return all peopleId's that are not available and...

ok here you go

CREATE TABLE [dbo].[Appointments](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Start] [smalldatetime] NOT NULL,

[End] [smalldatetime] NOT NULL,

CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

ok thanks for the reply. I'll draft something up and post it asap.

i missed out 12:01 and that there's a PersonId in my peopleavailability/resources table

my appointments table contains smalldatetimes for start and end datetimes. one appointment per row

appointment

-------------

id

startdatetime

enddatetime

peopleavailability

----------------

id

startdatetime

enddatetime

availtype (Available,Sick,On holiday, etc)

I have a calendar table that contains dates and a times table that contains...