Home Forums SQL Server 7,2000 T-SQL Limitation of Varchar 8000 in executing a dynamic MDX inside stored Procedure RE: Limitation of Varchar 8000 in executing a dynamic MDX inside stored Procedure

  • May 19, 2006 at 12:07 pm

    #639074

    Yes!

    use two ( several) variables the concatenate those in the exec statement like:

    select @str1 =  '... ' -- up to 8000

            , @str2 = '...' -- up to 8000

     


    * Noel