Jeff Smith Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server

Non-Deterministic UDF's – Custom Aggregate and Cumulative Functions

User Defined Functions (UDF’s) are just about my favorite thing in SQL 2000.I thought the possibilities to be endless, until I realized that they were designed to be completely deterministic:each call to a UDF with the same arguments should always return the same value, and during the evaluation of a UDF it cannot make any changes to the state of the database. Read more →