Forum Replies Created

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

  • RE: Lowest Child in recusive query

    Sean Lange (1/14/2015)

    edberg16 (1/14/2015)

    Mark,

    I am trying to run the query without Path column but I end up with limited result set.

    Any suggestions.

    Thanks.

    What does that mean? Can you share the code...

    January 14, 2015 at 4:22 pm

    #1770298

  • RE: Lowest Child in recusive query

    Mark,

    I am trying to run the query without Path column but I end up with limited result set.

    Any suggestions.

    Thanks.

    January 14, 2015 at 3:36 pm

    #1770280

  • RE: Lowest Child in recusive query

    Mark Cowne (1/13/2015)

    edberg16 (1/13/2015)

    Thanks Mark Cowne.

    When I try to run the query, its giving following error:

    A non-recursive WITH clause or view should not reference itself within its own definition.

    Works...

    January 13, 2015 at 11:19 am

    #1769901

  • RE: Lowest Child in recusive query

    Thanks Mark Cowne.

    When I try to run the query, its giving following error:

    A non-recursive WITH clause or view should not reference itself within its own definition.

    January 13, 2015 at 10:15 am

    #1769872

  • RE: Lowest Child in recusive query

    Thanks Sean.

    CREATE TABLE #tree

    (

    Childid varchar(20),

    ...

    January 13, 2015 at 9:14 am

    #1769858

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