No one has ever done this???? Any suggestions at all?

Thanks

Mark

That is correct, they try to make a reservation. The SELECT query would check to see if they can and if they can it can either return something saying...

When you make a reservation it goes in the Reservation Table. That is the only table I need to query against.

After thinking about what you said in your last...

OK maybe this will help. Insert the first INSERT only. We can assume that reservation is already in the database w/o any problems.

then

If you performed a SELECT with the...

Yes. I think I see your confusion now. We can assume:

CheckInDate = 11/11/2008

CheckOutDate = 11/14/2008

RunType = Large

RunNo...

OK I'll try.

ok assumption that the user wants the:

CheckInDate = 11/11/2008

CheckOutDate = 11/14/2008

RunType = Large

RunNo ...

Lynn,

First of all thank you for your suggestion. As a newbie I can use all the help I can get.

What I am trying to accomplish if a reservation is...

In this case ClientID and the times are not needed. I modified everything. Should be able to still use the previous data file. Thanks for your patience.

CREATE...

OK gotcha. (I'm learning slowly)

ok assumption that the user wants the:

CheckInDate = 11/11/2008

CheckOutDate = 11/14/2008

RunType = Large

RunNo ...

CREATE TABLE [dbo].[Reservation](

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

[ClientID] [int] NOT NULL,

[PetID] [int] NOT NULL,

[CheckInDate] [datetime] NULL,

[CheckInTime] [datetime] NULL,

[CheckOutDate] [datetime] NULL,

[CheckOutTime] [datetime] NULL,

[Reservation] [char](1) NULL CONSTRAINT [DF_Reservation_Reservation] DEFAULT ('N'),

[RunType] [varchar](50) NULL,

[RunNo]...

ReservationIDint(identity - key)

CheckInDatedatetime

CheckInTimedatetime(not needed in this query)

CheckOutDatedatetime

CheckOutTimedatetime(not needed in this query)

Reservationchar(1)(Y if they have a reservation, N if not)

RunType ...

Funny both times it looked like it posted correctly. Never had this problem on other forums. Trying again.

IF (SELECT Count(Reservation)

FROM KRIS.dbo.Reservation

WHERE RunNo = @RunNo AND

RunType =...

Ooops.. the query didnt paste correctly

IF (SELECT Count(Reservation)

FROM Reservation

WHERE RunNo = @RunNo AND

RunType = @RunType AND

PetCheckedIn = 'Y' AND

Reservation.Deleted != 'Y' AND

RunType = @RunType AND

(CheckInDate ...