views:

25

answers:

1

The SQL that Business Objects generates seems to be stuck in a bygone era for SQL joins -- it insists on using the old Sybase outer-join syntax (*=, etc.), which is illegal in SQL Server 2005 when running at level 90. Is there an option somewhere to make it use modern join syntax (i.e., joining using the JOIN keyword rather than using commas in the FROM statement)?

+1  A: 

From memory, there's a universe parameter called ANSI92 that does exactly what you want.

Pondlife
That looks promising -- thanks!
Ewen Cartwright