Posted by Erland Sommarskog on 05/23/06 00:33

(agarwalshuchi@gmail.com) writes:
> Now i execute the entire statement as
>
> exec('SELECT a.* FROM
> OpenRowset(''MSOLAP'',''DATASOURCE="RAPID-CHRISTUS"; Initial
> Catalog="MRS";'',' + @mdx1 + mdx2 ') as ' )
>
> Still error comes that :
> Unclosed quotation mark before the character string 'WITH MEMBER ..
>
> ('With member' is the starting statement of my MDX query)
>
> Is there any other way to connect to OLAP server and execute an MDX
> statement with a Length greater than 8000 chars

Have a look at http://www.sommarskog.se/dynamic_sql.html#OPENQUERY
for some tips.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: My boss beats me
• Prev in forum: Re: Returning multiple rows from a stored procedure
• Thread view: Re: Probem in executing a long Dynamic MDX from SQL server

[Reply to this message]