MS-SQL Hierarchical Queries

by Elsewhere 3 Replies latest jw friends

  • Elsewhere
    Elsewhere

    Something SQL2000 is lacking is a function or SELECT clause that will return a Hierarchical Query based on records with recursive Parent / Child references.

    I need to make a SQL query that does just this. Does anyone have any ideas on how I can do this in SQL2000?

  • damselfly
    damselfly

    If only I had an iota of a clue of what your post said I would help you out.

    Does this mean damselflies are dumb?

  • Elsewhere
    Elsewhere
    Does this mean damselflies are dumb?

    Naaa... this is just Geed Speek for some programming stuff. No different than if you did not understand the terminology of someone who scuba dives.

  • FMZ
    FMZ

    Else, the best I have managed up to now in doing that is just writing it code-side rather than db-side. Never did reckon much to custom db-side functions.

    FMZ

Share this

Google+
Pinterest
Reddit