Link to home
Start Free TrialLog in
Avatar of Morpheus7
Morpheus7

asked on

Set value for variable based on day of week

Hi,
Is there a way to assign a value to a variable based on the day of the week? For example if the day is Monday, set the variable to 50,
if not Monday, sed it to 100.
Using SQL Server 2005.

Any help would be appreciated.

Many thanks
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial