• 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