Home Forums SQL Server 2005 T-SQL (SS2K5) how to avoid duplicate business logic RE: how to avoid duplicate business logic

  • October 2, 2012 at 8:03 am

    #1544395

    norbert.manyi (10/2/2012)

    ChrisM@Work (10/2/2012)

    If you can't code it up as a view, then it's unlikely that you can code it up as a query.

    You could still do it as a quite complex function, but I guess that would be wasteful.

    Also, I am not stuck on functions vs views; if there are any other ideas/tips that I could use to keep the business logic more manageable, please mention them...

    Norbert - check out the two articles by Paul White in my signature block. Although the subject is APPLY, they will give you some useful information for constructing and using iTVF's (inline table-valued functions).

    “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