Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Problems with CTE (recursive queries) RE: Problems with CTE (recursive queries)

  • November 26, 2015 at 1:21 am

    #1842459

    Luis Cazares (11/25/2015)

    I see the same thing as Sean, there's no hierarchy in what you posted. There's a parent/child relationship, but it won't go multiple levels.

    I wish to have something similar (also the layout should reflect the hierarchical tree)

    horror

    | titolo 1

    | titolo 2

    fantascienza

    | titolo 3

    | | titolo n (this is a second level)

    but now you make me understand my relationship between tables don't permit this.

    Luis Cazares (11/25/2015)

    And please, next time post sample data like this:

    Sorry, next time I'll post code in a right way

    Thanks

    Mara