>>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


Oh, I thought he might be trying to get it to work like an Automatic variable. like @@Rowcount. The only reason I say it, is because I once wished I could create some constants globally to just access as needed in any procedure. Is there a way to do it.

Thanks
Respectfully (as you guys answer most of my questions too!)
Jeff