Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Comparing rows in same table

    Just to confirm its working as required, thanks alot for helping me.

    cheers

    May 30, 2012 at 8:24 am

    #1494704

  • RE: Comparing rows in same table

    Thanks Chris and Mark

    Mark i think your code will work, i am going to test now, need to make small modifcation to update the last feild "CountEpisode"

    Thaks alot for your...

    May 30, 2012 at 7:55 am

    #1494677

  • RE: Comparing rows in same table

    ChrisM@Work (5/30/2012)

    jinkazama_11 (5/30/2012)

    Thanks for your response

    The total number of records can be more than 3, I can only use your query if there are only 2 records for one client.

    I...

    May 30, 2012 at 7:22 am

    #1494652

  • RE: Comparing rows in same table

    jinkazama_11 (5/30/2012)

    jinkazama_11 (5/30/2012)

    Thanks for your response

    Let's see if you can figure this out with a little help.

    Use an inner join, and include SeqNo, something like this:

    a.seqno+1 = b.seqno

    I...

    May 30, 2012 at 7:18 am

    #1494649

  • RE: Comparing rows in same table

    jinkazama_11 (5/30/2012)

    Thanks for your response

    Let's see if you can figure this out with a little help.

    Use an inner join, and include SeqNo, something like this:

    a.seqno+1 = b.seqno

    I have...

    May 30, 2012 at 7:16 am

    #1494648

  • RE: Comparing rows in same table

    Thanks for your response

    The total number of records can be more than 3, I can only use your query if there are only 2 records for one client.

    I would like...

    May 30, 2012 at 6:58 am

    #1494636

Viewing 6 posts - 1 through 6 (of 6 total)