Home Forums SQL Server 2008 SQL Server 2008 - General How to avoid Union/Union All? RE: How to avoid Union/Union All?

  • December 27, 2014 at 11:59 am

    #1766569

    Praxo (12/27/2014)

    Limitation I was referring is from front end side, which as I mentioned generates the SQL dynamically. The front end is not having this framework and does not support creating SQLs with UNION ALL .

    I understand the UNION ALL option is the right option in this case, however since front end does not support UNION ALL, we need to find some other alternative to get the desired results.

    Let us know if there can be any other option.

    There absolutely is. Stop building SQL code in the front end and use a stored procedure. 😉

    It's actually difficult for me to believe that the front end can't produce or use a UNION ALL but I'm also not a front end programmer. Someone else will have to jump in here.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)