Jules,

With a little "and to or" change, this trigger does the job.

Script below should cover possible situations to locate all reserved positions for specific date interval:

declare @start smalldatetime

declare @end smalldatetime

set @start...

Jules, thanks for the reply. Your solution will work only if the dates are the same.

If i try to run the following script,

insert into jobschedule values ('3/29/2004', '4/16/2004', 4)

error...