Post reply

UDF recursion and Cursors

  • February 4, 2003 at 2:55 pm

    #448041

    Have you tried doing a self-join,

    eg:

    select d1.DomainID , d2.DomainID

    from Domain d1

    inner join Domain d2

    on d1.ParentDomainID = d2.DomainID

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply