No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
i am trying to check availability of a room i have the following code: ALTER procedure [dbo].[CheckAvailability] @checkIn datetime, @checkout datetime as Select r.RoomName, RoomNO, [Description],Location, RoomPic, Price from [Room-Type] t , Room r, Booking b where r.TypeNo= t.TypeNo AND r.RoomName Not IN( Select b.CheckinDate from Booking b where ( … |
|
i keep get this error i dont what to do anymore Year, Month, and Day parameters describe an un-representable DateTime. |
|
i have the following sql query i seem to be having this error "Incorrect syntax near the keyword 'INSERT'" |
|
how do in go about in order to check availabili in a form.. |