>I'm not sure how well that would work. Values in the table need to be returned in a result or result set at the beginning of each procedure.
Sure it would work.
CREATE TABLE constants (
OneItemDisc float,
TenItemDisc float)
Inside a stored procedure, you could do something like this:
DECLARE @OneItemDisc float, @TenItemDisc float
SELECT
@OneItemDisc = OneItemDisc,
@TenItemDisc = TenItemDisc
FROM
constants
...
-Mike