Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-12 : 08:12:37
|
| Jason writes "I'm trying to pull data using possible date ranges. For instance, I may be looking for all data entered > 01/03/03 and < 09/10/03. I'm trying to pass the operators ( <,>, =<, etc...) as parameters. My stored procedure works in query analyzer. However, I'm using VB6 to run the stored procedure and I believe the problem is in passing the operators as parameters to the stored procedure." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-12 : 08:49:46
|
| Why are you making life hard for yourself? Instead of passing > < and whatever, just have parameters for the dates and another parameter(s) that indicates the range of the dates you enter.-------Moo. :) |
 |
|
|
|
|
|
stored procedure parameters