none
OpenQuery character limit

    Question

  • I am executing an MDX query from T-SQL.  I am using OpenQuery, and there is a need to allow the query to go beyond 4 or even 8 thousand character limit as it includes a number of query scoped calculated members that encapsulate business logic.    How can I go beyond this limit without much trouble?  Suggestions are very welcome

    Thanks!




    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx
    Wednesday, December 15, 2010 3:28 AM

Answers

  • Unless you can do multiple separate queries within the limit of 8K, I don't see a way as the limitation is stated in the BOL.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by KJian_ Wednesday, December 22, 2010 5:04 AM
    Wednesday, December 15, 2010 3:36 AM
    Moderator