Public feed
#377739
+-------------------------------------------------------------------------------------------- | xxxx Uniqueness Check on fields +--------------------------------------------------------------------------------------------*/ -- org_name must be unique (case insensitive) if (SELECT count(*) From NSS_ORGANISATIONS WHERE UPPER(ORG_NAME) = UPPER(@org_name) AND org_id <> @id_col) > 0 Begin raiserror('0530103: This entry is not unique (Organisation name). Please select another entry and attempt to save again.',1,1) -- raise error return 3 -- return indicating error End -- org_abbrevited_name must be unique (case insensitive) if (SELECT count(*) From NSS_ORGANISATIONS WHERE UPPER(org_abbreviated_name) = UPPER(@org_abbreviated_name) AND org_id <> @id_col) > 0 Begin raiserror('0530103: This entry is not unique (<Organisation Abbreviated Name>). Please select another entry and attempt to save again.',1,1) -- raise error return 3 -- return indicating error End