Yes, Lynn, it works. But just on my Laptop. On my office's desktop, there's a Error Message:

'row_number' is not a recognized function name.

Both my laptop and office's desk are installed SQL Server 2008 SP1 :ermm:

---

OMG, I find out our CMS databse is SQL 2000.

Is ROW_NUMBER() function not available in SQL 2000 ?

So maybe I must wirte a ROW_NUMBER() function for SQL 2000 ?