SQL80001 - incorrect syntax near ')'
SQL80001 is a SQL Server error message. SQL Server doesn't support the old Oracle (+) syntax for outer joins.

Re-write your SQL using LEFT/RIGHT OUTER JOIN .... ON .....