• Jeff Moden (12/27/2014)


    It's actually difficult for me to believe that the front end can't produce or use a UNION ALL

    You'll probably find that the senior guru expert development lead decided to write his own inspired framework for generating database queries and now every project must use that framework because it's perfect and nothing else could approach that ideal work of art.

    You'll probably also find that it's riddled with SQL injection vulnerabilities, implicit conversion problems and other strange behaviours.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass