Date Range Prompts

[angi]

Is there an elegant way to tie two date prompts together to create a single date range prompt.

For example, I have a Low Date prompt and a High Date prompt that are fed into a stored procedure that contains "ActivityDate between @LowDate and @HighDate". How do I make the Low Date and High Date prompts required so that a user must complete them both to make the stored procedure run correctly?

Thanks.

 

[mrdenny]

All stored procedure paramaters are required unless you assign them a default.

You would need to handle the pretty part via the GUI that calles the procedures. If there isn't a GUI and people are running the procedure via T/SQL there isn't a pretty way to handle it.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com