Given the original description of the UDF, I'd consider it NOT DETERMINISTIC.
I used to use DETERMINISTIC as more of an "it's ok to cache this", but
after discussions with Kent...I quit doing so. Now the only thing I
use DETERMINISTIC on are functions that just look at the input
parameters; date conversion for example.
If James really wants to define this as DETERMINISTIC, I'd suggest
passing in the user ID as well...but I'd guess that he's also looking
at a DB table or something....which in my book automatically makes it
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact