Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 7 DTS Date Parameter to Stored Procedure
Message
From
25/08/1999 18:00:58
Michael Levy
Cincinnati, Ohio, United States
 
 
To
25/08/1999 13:43:29
Robert Byrd
National Association of Homebuilders
Washington, District of Columbia, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: SQL 7 DTS Date Parameter to Stored Procedure
Miscellaneous
Thread ID:
00257541
Message ID:
00257661
Views:
19
What about using a CASE expression. Maybe something like :

EXECUTE storeprocedure (CASE WHEN DTSSource(column) = '19900101' THEN NULL ELSE DTSSource(Column))

??

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform