yes,

for a city we have few locations.i.e. they are related.

my problem is for a particular day there may be many slots for booking the hall . i also want to...

the tables we have used are

CONFERENCEMASTER

CONFFERENCEID int IDENTITY(1,1) NOT NULL,

CONFFERENCENAME varchar](20)

LOCATIONID int

ERP_CONFFERENCEAVAILABLE

CAID int,

CONFFERENCEID int,

CITYID int,

BOOKINGDATE datetime,

FROMTIME varchar(10)

TOTIME varchar(10)

AVAILABILITY char(1) DEFAULT ('A'),

REASON varchar(100) ,

FROMDATE datetime,

TODATE datetime,

NOOFMEMBERS int,

i...