SQL window function

Just read the SQL cookbook and learn userful sql windows function.

Over()

http://msdn.microsoft.com/en-us/library/ms189461.aspx

NTILE

http://msdn.microsoft.com/en-us/library/ms175126.aspx

TSQL Date and Time function

http://msdn.microsoft.com/en-us/library/ms186724.aspx

WITH common_table_expression (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms175972.aspx

See a good list of SQL tutorial while googling:

http://www.databasejournal.com/article.php/3649246

http://www.databasejournal.com/features/mssql/article.php/3780311/Exploring-SQL-2005146s-Ranking-Functions-150-NTILE-and-ROWNUMBER.htm