• Here is MSDN article that shows processing order for SELECT:

    http://msdn.microsoft.com/en-us/library/ms189499.aspx

    --Vadim R.