Post reply

T SQL Problem

  • May 18, 2011 at 10:10 pm

    #1326882

    Hi heb1014,

    This is because, both records are not consecutive.

    Regards

    Ashok

  • May 19, 2011 at 5:33 am

    #1326962

    Hi lulian,

    I am waiting for your reply, I hope you will come back, Please help..

    Regards

    Ashok

  • May 19, 2011 at 7:05 am

    #1327033

    When you say that the records are not consecutive, do you mean that they are not physically in consecutive order in the table? If so, how are you ordering the records? Is the table a heap?

  • May 20, 2011 at 6:40 am

    #1327621

    Hi Ashok,

    What I would do from here is:

    1. add an identity_column to the initial table, so that we know what consecutive means.

    2. create a CTE recursive query to merge the consecutive records (cursor is not allowed, but what about CTE?)

    3. run the select query with order clause from the previous posts

    I get back as soon as I get some moments, I am catched in other activities at the moment.

    Regards,

    Iulian

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply