IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_ResRoomLineGenerateAvail1')
CREATE NONCLUSTERED INDEX IX_ResRoomLineGenerateAvail1
ON [dbo].[RESERVATIONROOMLINE] ([ArrivalDate],[DepartureDate])
INCLUDE ([BookedTypeNumber],[RoomNumber],[NumberOfRooms],[ArrivalTime],[DepartureTime],[Adults],[Children1],[Children2],[ProductNumber],[ProductNumber2],[Day3],[ProductNumber3],[Day4],[ProductNumber4],[Price],[FirstPrice2],[FirstPrice3],[FirstPrice4],[Day2],[StatusRL],[FK_ReservationGroup])
GO