I have a customer who uses something like:
.....OR CALCDUEDATE < GetDate() + 7.....
in a sproc.
I think I have read something about functions that doesn't
return the same output using the same input (they have a
name I cannot remember) and that they should be avoided in
logic because of problems pre-compiling the stored
Would it be a better idea just to make a parameter to the
sproc e.g.: SearchDate, and then let the application do
the date retrieval and adding of 7 days and then just cal
the sproc with the result of this and ...