0 Comments

see: http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

Example query

select
      rank() over (
            order by
                  sl.[Title],
                  sl.[Description],
                  sl.[Order]
      ) as rank,
      sl.[Title],
      sl.[Description], sl.[Order]
from
      [ScoreList] sl
order by rank

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

Data flows and good DDD architecture in .NET Core and Entity Framework (EF)

      # Introduction From the blog post at https://medium.com/@jpdeffo/domain-driven-design-ddd-in-microservice-architecture-for-nutshell-19c7c579009a and code at https://github.com/Defcoq/DDD  I have learned how to architect a .NET Core project by using DDD principals. The main thing you will have to realize, when you come from a layered architecture, is that the logical flow of data, does not correspond with the project references in Visual Studio.              # Logical dataflow…