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.