• fweymouth - Wednesday, November 22, 2017 8:40 AM

    What I'm thinking is that each column must have a separate constraint that restricts the total weight to the 1/4lb per inch.cubic.

    No, you only need a single constraint.  You can do it the way Thom showed you, with a computed (persisted) column, or you can put the whole calculation in the constraint itself:

    CREATE TABLE Shipment (BoxID int IDENTITY(1,1),
       Width decimal(6,2),
       [Length] decimal(6,2));

    ALTER TABLE Shipment ADD CONSTRAINT SizeRestriction CHECK (Width * [Length] <= 10);

    John