vk-kirov (12/8/2009)

---

mohd.nizamuddin (12/8/2009)

---

However, in the example the functions Count(*), SUM, MAX, MIN etc are not a deterministic function.

This is incorrect. Check BOL (Deterministic and Nondeterministic Functions): http://msdn.microsoft.com/en-us/library/ms178091.aspx

All of the aggregate and string built-in functions are deterministic.