Home Forums SQL Server 2005 SQL Server 2005 General Discussion Sequence-numbering groups RE: Sequence-numbering groups

  • October 21, 2010 at 8:55 am

    #1240380

    gmrose (10/20/2010)

    After I finish reading the article, I will need to build a new statement using its suggestions. The one that I built based on Lutz's solution has been running for over 30 minutes so far and hasn't finished yet.

    Thanks anyways.

    gmrose

    How many rows does your table have? And what indexes?

    Please post complete DDL for the table in question.

    Edit: the actual execution plan would be great, too...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]