Home Forums Database Design Relational Theory Circular reference RE: Circular reference

  • September 10, 2010 at 5:02 am

    #1219077

    the_rutter (9/10/2010)

    I'm actually a .NET developer with little SQL experience. I noticed this circular reference in a new project I am working on and it raised alarms in my head. I have very vague memories of this sort of thing being bad from my school days...

    I'd classify it as bad in this case as the people who created and maintained this system have left.

    Thanks for all the help.

    It would be interesting to see, if you have the time.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden