Nope It didn't work. Also I want it to be using WINDOW clause in SQL 1999.
Any help will be appreciated.

Also any idea about first qustion??