Forum Replies Created

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

  • RE: Problems with CTE (recursive queries)

    serg-52 (11/26/2015)

    Luis Cazares (11/26/2015)

    Be aware that the example doesn't represent a recursive query. That's just a query using union all

    Yes, exactly. If OP needs more levels we need more info...

    November 27, 2015 at 1:33 am

    #1842579

  • RE: Problems with CTE (recursive queries)

    serg-52 (11/26/2015)

    Yes, you can currently have only 2 levels.

    CREATE table categoria(

    [id_categoria] [int] NOT NULL,

    [categoria] [nvarchar](50) NULL

    );

    INSERT INTO categoria

    VALUES

    (1, 'horror'),

    (2, 'fantascienza');

    CREATE table film(

    [id_film]...

    November 26, 2015 at 8:40 am

    #1842523

  • RE: Problems with CTE (recursive queries)

    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...

    November 26, 2015 at 1:21 am

    #1842459

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