I have a Stored Procedure in SQL 2000 which build a Long MDX query .Then i
connect to OLAP
and execute the query .The dataset returned is used in Report.
When my dynamic query exceeds the varchar (8000) limit ,
Error that comes :
''Unquoted string in the Query'' .
This error comes only when my query exeeds the 8000 char limit. There
is no syntactical error in the query.
I have used following statement to connect to OLAP and execute my
exec('SELECT a.* FROM
Catalog="MRS";'',' + @mdxqry + @mdxqry1+') as a')
varchar @mdxqry has a length of 8000 chars and
varchar @mdxqry1 has a lenth of 5000 chars.
Is there a way to execute a dynamic query in SQL 2000 whose length exeeds the varchar(8000) limit.