using …

Pure C#

Home

Categories
- .Net (12)
- .Net 3.5 (8)
- .Net 4.0 (14)
- .Net Framework (8)
- .Net Remoting (3)
- .Net Services (4)
- Abstract (1)
- Active Directory (6)
- Ado.Net (9)
- ADO.NET Data Services (3)
- ADO.NET Entity Framework (7)
- Ajax (2)
- Ajax Control Toolkit (2)
- Alt.Net (13)
- Analysis Services (3)
- Android (1)
- APEX (1)
- Applet (2)
- Array (8)
- Asp.Net (29)
- Asp.Net Help (1)
- Asp.Net Upload (1)
- asp:MultiView (1)
- AutoCompleteExtender (2)
- AutoIncrement (1)
- AutoMapper (2)
- Azure (6)
- Between (1)
- Binary Data (3)
- C# (20)
- Caching (2)
- Case When (3)
- Cast (5)
- Castle Active Record (3)
- Castle Project (1)
- CentOS (3)
- Certification (2)
- ClearType (1)
- Code Generation (1)
- Code Snippets (1)
- CodeGear (2)
- CodePage (1)
- CodePlex (1)
- Common Table Expressions (2)
- Communication (1)
- Components (1)
- Convert (2)
- Cross-Tabs (3)
- Css (1)
- CTE (10)
- Custom Paging (1)
- Data (6)
- Data Migration (1)
- Data Mining (2)
- DataReader (2)
- DataSet (7)
- DataTable (5)
- DataView (2)
- Date (1)
- DateTime (7)
- Db Converters (1)
- DBCC (1)
- DBREINDEX (1)
- Deadlock (3)
- Debian (4)
- Debugging (6)
- Declare (1)
- Decoding (1)
- Delegate (12)
- Delphi (1)
- Dense_Rank (3)
- Dependency Injection (3)
- Design Pattern (10)
- Desktop Recording (1)
- Developer (33)
- development (2)
- DHTML (1)
- Distributed Systems (3)
- Domain Driven Design (4)
- Duplicate Data (1)
- Eclipse (6)
- Encoding (5)
- Enterprise Library (9)
- Entity (9)
- Entity Framework (3)
- Enum (8)
- Error Management (2)
- Exception (2)
- Exist (1)
- FieldInfo (2)
- Find (10)
- Form Controls (1)
- Forms Authentication (1)
- Framework (4)
- Full Text Search (1)
- Functions (5)
- GAT (1)
- Generic (12)
- Geneva (2)
- git (1)
- github (1)
- HAVING (1)
- Https (2)
- IIS (9)
- INDEXDEFRAG (1)
- Inheritance (1)
- Installer (1)
- Instead Of (3)
- Integration Patterns (1)
- Integration Services (2)
- Java (17)
- java applet tag (4)
- java embed tag (5)
- java object tag (5)
- Java.Util (1)
- JavaScript (19)
- Journalist (1)
- JQuery (2)
- JRE (1)
- JScript (2)
- Kernel (1)
- Lazy Loading (1)
- LinQ (13)
- Linux (47)
- List (14)
- Localization (1)
- Lock (1)
- Log4Net (1)
- Loose Coupling (2)
- Mail (5)
- Mapping (1)
- MasterPage (1)
- Memory Leak (2)
- Merging Tool (1)
- Messaging (1)
- Mevlana (1)
- Microsoft Expression Blend (1)
- Microsoft Office System 2007 (1)
- Microsoft Office Word Team (1)
- Microsoft Solutions Framework (1)
- Microsoft.Web.Administration (1)
- MIME (1)
- Model (1)
- Model View Presenter (2)
- Mono (1)
- MooTools (1)
- Mozilla (1)
- Msdn (3)
- Msmq (1)
- MVC (5)
- MyGeneration (1)
- MySQL (2)
- Naming Conventions (1)
- NedirTv (1)
- Network (1)
- newid() (1)
- NHibernate (21)
- NLog (1)
- NLS (1)
- Ntile (3)
- Null (4)
- NUnit (1)
- ObservableCollection (3)
- office (5)
- OLAP (2)
- Open XML (20)
- Open XML Object Model (14)
- OpenID (1)
- OpenSuse (15)
- Oracle (14)
- Oracle Certified Professional (1)
- ORDER BY (2)
- ORM (1)
- Output (4)
- PageLoad (3)
- Parallel Programming (1)
- Partition (1)
- Pattern & Practices (2)
- PDF (1)
- Php (2)
- Phyton (4)
- Pivot Tables (3)
- PLSQL (4)
- POP3 (1)
- PostBack (3)
- PowerShell (5)
- Predicate (2)
- Producer-Consumer Pattern (1)
- Profiler (1)
- Raiserror (10)
- Rand (2)
- Random Number (2)
- Rank (4)
- Ranking (1)
- Recursive (3)
- RedHat (1)
- Regular Expressions (2)
- Replace (1)
- Report (3)
- Report Builder (3)
- Report Designer (2)
- Report Server (3)
- Reporting Services (6)
- Resource (1)
- Resource Leak (1)
- Reverse (2)
- Rhino Mocks (5)
- Round (1)
- ROW_NUMBER (6)
- Runtime Serialization (1)
- SAP (1)
- Search & Find (1)
- Search Engine (1)
- Select Into (1)
- Serialization (3)
- Server Control Library (1)
- Server Side Paging (1)
- Service (2)
- Service Pack (1)
- SET (1)
- Setup (1)
- SharePoint (11)
- SharePoint 2010 (7)
- Silverlight (16)
- Smart Client Guidance (1)
- Snippet (1)
- SOA (1)
- SortedSet (1)
- Source Control Systems (3)
- split (5)
- sp_executesql (2)
- SQL (59)
- SQL Collation (2)
- Sql Server (119)
- Sql Server 2008 R2 (4)
- SQL Server 2011 (1)
- SQL Server 2012 (2)
- SQL Server Backup (3)
- Sql Server Error (5)
- Sql Server Join (8)
- Sql Server Management Objects (2)
- Sql Server Restore (1)
- SqlBulkCopy (1)
- SQLCLR (4)
- sqlserverpedia (3)
- SQUARE (1)
- Ssl (1)
- Stored Procedure (21)
- Stream (2)
- Subclipse (1)
- Subversion (4)
- Synchronizers (1)
- Table (1)
- Team Foundation Server (10)
- TeamCity (1)
- Telerik (14)
- Telerik Rad Ajax Manager (1)
- Temporary Table (2)
- Testing (1)
- TEXT (1)
- TextBox (1)
- TimeSpan (3)
- Tool (3)
- TOP (2)
- TOP n (1)
- Transact-SQL (117)
- Transaction (4)
- Tree (3)
- TreeView (5)
- Trigger (23)
- Try Catch (3)
- TSQL N Prefix (2)
- Ubuntu (2)
- Uncategorized (13)
- Unicode (1)
- UNION (2)
- UNION ALL (2)
- Unit Test (2)
- Unit Testing (1)
- UNPIVOT (1)
- Update (4)
- Update with Join (3)
- User Control (8)
- Velocity (1)
- ViewState (4)
- Visual Studio (5)
- Visual Studio 2005 (8)
- Visual Studio 2008 (4)
- Visual Studio 2010 (7)
- Visual Studio Team System (3)
- VisualSVN (3)
- VMware (3)
- VSTO (5)
- WareHouse (1)
- WCF (12)
- Web Application Project (1)
- Web Client Software Factory (2)
- Web Client Software Factory Contrib (1)
- Web Design (2)
- Web Forms (1)
- Web Service Software Factory (2)
- Web Services (12)
- WebRequest (1)
- WebResponse (1)
- Where Clause (1)
- While (1)
- Windows (1)
- Windows Client (1)
- Windows Forms (1)
- Windows SDK (1)
- Windows Server 2008 R2 (3)
- WITH (4)
- WORD (2)
- WordML (5)
- WPF (3)
- WSDL (1)
- WSE (13)
- X509 (3)
- X64 (1)
- XACT_ABORT (1)
- XACT_STATE (1)
- XHtml (1)
- XML (6)
- XPS (1)
- xUnit (1)
- Zend (1)
Category Cloud

.Net .Net 4.0 Alt.Net Asp.Net C# Delegate Developer Generic Java JavaScript LinQ Linux List NHibernate OpenSuse Open XML Open XML Object Model Oracle SharePoint Silverlight SQL Sql Server Stored Procedure Telerik Transact-SQL Trigger Uncategorized WCF Web Services WSE
Archives
- May 2013 (1)
- February 2013 (4)
- June 2012 (1)
- May 2012 (1)
- April 2012 (3)
- March 2012 (11)
- February 2012 (1)
- January 2012 (1)
- December 2011 (6)
- November 2011 (1)
- October 2011 (5)
- July 2011 (5)
- June 2011 (8)
- March 2011 (1)
- February 2011 (12)
- January 2011 (3)
- December 2010 (6)
- November 2010 (7)
- September 2010 (3)
- August 2010 (5)
- July 2010 (23)
- June 2010 (10)
- May 2010 (1)
- April 2010 (1)
- March 2010 (6)
- February 2010 (17)
- January 2010 (5)
- December 2009 (5)
- November 2009 (6)
- October 2009 (10)
- September 2009 (29)
- August 2009 (35)
- July 2009 (16)
- June 2009 (5)
- May 2009 (71)
- April 2009 (22)
- March 2009 (92)
- February 2009 (10)
- January 2009 (82)
- December 2008 (68)
- November 2008 (114)
- October 2008 (60)
Calendar

March 2009

M T W T F S S

« Feb Apr »

1

2 3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 26 27 28 29

30 31

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

About these ads

This entry was posted on 20/03/2009 at 12:18 and is filed under Dense_Rank, Ntile, Rank, ROW_NUMBER. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply Cancel reply

Enter your comment here...

Please log in using one of these methods to post your comment:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

« Returning Ranked Results with Microsoft SQL Server 2005 By Scott Mitchell

Using select into to create a temporary table »

Follow

Follow “using ...”

Powered by WordPress.com

%d bloggers like this: