Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Defining constants
Message
From
11/10/2001 22:16:48
 
 
To
11/10/2001 12:08:54
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00566957
Message ID:
00567383
Views:
11
>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
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform