Jim Russell (9/16/2008)
FWIW - I noted a reference to @today (or something) earlier in your comments. I have been bit big time by T-SQL deciding that a time variable (e.g. from GetDate) was nondeterministic, even if the date/time parameter was passed in as a variable. I think it is a bug, but can't get anyone to agree.
I disagree.
I have several UDF's taking datetime parameter, and all are deterministic.
_____________
Code for TallyGenerator