Your answer to the last FAQ is inaccurate. You don't HAVE to use PARTITION BY with the DENSE_RANK() function. If you don't use it (as in your first example) then...
I recently discovered the original stored procedure that you referenced. The one issue that I have with it is the limitation that it runs on ALL databases! There...