Grouping data

1.)http://pratchev.blogspot.com/2008/03/grouping-with-rownumber.html

2.)http://download.cnet.com/Export-Query-to-Excel-for-SQL-Server/3000-10254_4-10604504.html