Home Forums SQL Server 2008 T-SQL (SS2K8) Incrementing code to add code RE: Incrementing code to add code

  • March 20, 2013 at 5:43 am

    #1598841

    akberali67 (3/20/2013)

    CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

    davidandrews13 (3/20/2013)

    are you doing something that a Recursive CTE could resolve?

    http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/

    sql handles that just fine as long as you rememeber to preface every field with it's table name.

    SELECT

    T1.*

    T2.*

    FROM MyTable T1

    LEFT OUTER JOIN MyTable T2 On T1.ID = T2.ID +1

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!