using …

Pure C#

Archive for the ‘ROW_NUMBER’ Category

SQL Server 2005 ranking functions – RANK(), DENSE_RANK(), NTILE()

Posted by esersahin on 20/03/2009


http://msmvps.com/blogs/martinpoon/archive/2006/09/22/SQL-Server-2005-ranking-functions-_2D00_-RANK_280029002C00_-DENSE_5F00_RANK_280029002C00_-NTILE_28002900_-.aspx

Posted in Dense_Rank, Ntile, Rank, ROW_NUMBER | Leave a Comment »

Returning Ranked Results with Microsoft SQL Server 2005 By Scott Mitchell

Posted by esersahin on 20/03/2009


http://www.4guysfromrolla.com/webtech/010406-1.shtml

Posted in Dense_Rank, Ntile, Rank, ROW_NUMBER | Leave a Comment »

SQL Server / T-SQL Tutorial

Posted by esersahin on 20/03/2009


http://www.java2s.com/Tutorial/SQLServer/CatalogSQLServer.htm

Posted in Cast, Common Table Expressions, Cross-Tabs, CTE, Functions, Instead Of, Pivot Tables, Raiserror, ROW_NUMBER, SQL, Sql Server, Sql Server Error, Sql Server Join, SQLCLR, Stored Procedure, Transact-SQL, Trigger, UNION, UNION ALL, Update with Join | Leave a Comment »

ROW_NUMBER (Transact-SQL)

Posted by esersahin on 17/03/2009


http://msdn.microsoft.com/en-us/library/ms186734(SQL.90).aspx

Posted in ROW_NUMBER, Transact-SQL | Leave a Comment »

Row_Number() function in SQL Server 2005 – Part II

Posted by esersahin on 26/11/2008


http://www.databasejournal.com/features/mssql/article.php/3577481/RowNumber-function-in-SQL-Server-2005–Part-II.htm

Posted in ROW_NUMBER, SQL, Sql Server, Transact-SQL | Leave a Comment »

Row_Number() function in SQL Server 2005

Posted by esersahin on 26/11/2008


http://www.databasejournal.com/features/mssql/article.php/3572301/RowNumber-function-in-SQL-Server-2005.htm

Posted in ROW_NUMBER, SQL, Sql Server, Transact-SQL | Leave a Comment »