Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Including a dynamic parameter in SPROC
Message
From
09/05/2007 13:16:47
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Including a dynamic parameter in SPROC
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01223878
Message ID:
01223878
Views:
60
I am creating a SPROC where I am filtering by a specific date, which I am passing in as a parameter. What I would like to do is if there is a date, show records on that date, otherwise show all records. How can I implement something like this?
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform