IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_RESERVATIONS_Status_ReferenceNumber')
	CREATE NONCLUSTERED INDEX IX_RESERVATIONS_Status_ReferenceNumber
	ON [dbo].[RESERVATIONS] ([Status],[ReferenceNumber])
	INCLUDE ([GuestNumber],[ArrivalDate])

