IF NOT EXISTS (SELECT Name FROM SysIndexes  WITH (NOLOCK) WHERE Name = 'IX_RESERVATIONCONFERENCELINE_BookedConferenceTypeNumber')
  CREATE NONCLUSTERED INDEX IX_RESERVATIONCONFERENCELINE_BookedConferenceTypeNumber
  ON [dbo].[RESERVATIONCONFERENCELINE] ([BookedConferenceRoomTypeNumber])
  INCLUDE ([ReservationConfLineNumber])
GO