I have a column RSEFlag that contains a flag value that is the sum of one or more of 1, 2, 4. I have separate table that contains the description of each of those flag values:
RSECode RSEDescription ------- -------------- 4 Environment 1 Reliability 2 Safety
I would like to constrain my RSEFlag column so that it is less than or equal to the sum of values from the RSE table.
Is this a worthwhile exercise and what is the best approach?