Re: MSSQL2005
The stored procedures use common table expressions (CTE's), which are a 2005 feature. They tend to be a lot faster than the other various techniques of paging data, so that's what I used.
It basically came down to deciding whether I should support an 8-year-old database, or cut the cord and go for the newer option. That said, I can't think of anything else that is 2005 specific, so if you wanted to alter the sprocs that use CTE's, you certainly could do so.
Jeff Putz
POP World Media, LLC