Home Forums SQL Server 2008 T-SQL (SS2K8) Recusion on Group and their subGroups- how can I solve this problem? RE: Recusion on Group and their subGroups- how can I solve this problem?

  • January 6, 2012 at 4:41 am

    #1429554

    Shamshad Ali (1/6/2012)

    Hello chrisM@home,

    There is one scenario in which the query is not returning me expected data when there is no any Parent exists in groupAssociation table ....

    Since you already have entities in the groupAssociation table which have no parent, shouldn't these be in the groupAssociation table also?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]