IF NOT EXISTS (SELECT NAME FROM SYSINDEXES  WITH (NOLOCK) 
               WHERE Name = 'IX_ReservationMain_Allotment')

	CREATE NONCLUSTERED INDEX [IX_ReservationMain_Allotment]
	ON [dbo].[RESERVATIONMAIN] ([AllotmentNumber],[REFERENCENUMBER])