How do I set Index to enforce that ONLY 1 QAID can own that order number,
but nothing else?

For example:

QAID [order] ErrorType
11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one QAID
number uses it.
11223 123456789 19 'VIOLATED cannot have same ErrorTypes -> UNIQUE INDEX
(QAID,[order],ErrorType)
11223 123456789 15
11223 123456789 NULL

11240 123456789 14 'VIOLATED -- order was owned by QAID 11223, therefore can
not used by different QAID

--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html

Reply via email to