Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Range Prompts

Status
Not open for further replies.

angi

Programmer
Apr 14, 2003
9
US
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.
 
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)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top