http://forums.asp.net/p/1299660/2535207.aspx#2535207 Lets say that I've got two tables: ROOM: ID_ROOM : int Name: Nvarchar(50) RESERVATION ID_RESERVATION : int // unique ID of reservation ID_ROOM : int // which room is reserved DATE: SmallDateTime //...