Skip to Content
0
Former Member
Sep 27, 2011 at 08:09 AM

BEGIN_SQL Statement for MS SQL Server

123 Views

Hi,

in Universe Designer query panel generates correct SQL with BEGIN_SQL (SET DATEFORMAT mdy) and END_SQL (ORDER BY ...) parameter values:

SET DATEFORMAT mdy

SELECT ...

FROM ...

ORDER BY ...

Web Intelligence only generates SQL script with END_SQL parameter value. The BEGIN_SQL statement is missing.

Does SQL Server 2008 support BEGIN_SQL?

We tried it with OLE DB and ODBC connection in BO 3.1 environment.

Thanks!