IF NOT EXISTS (SELECT * FROM IdentityFields WITH(NOLOCK) WHERE DBTableName = 'HALLSTATUSTYPEIDENTITY')
  INSERT INTO IdentityFields (DBTableName, HotelCustomerNumber, IdentityField, FKDepartment, Changedate) VALUES ('HALLSTATUSTYPEIDENTITY', -1, 1, -1, GETDATE())