Hi AndrewSQLDBA,

I'm trying to convert an access query to TSQL syntax.

"Query1..." was a query then change to a table. Will I be able to join it?

If not, how would I...

Hi Guys,

is this correct?

I've got the following syntax error:

ODBC --call failed

invalid object name Query1_EnrolmentsWithPlannedEndAfterModuleEnd

Thank you!

SELECT PU.m_reference AS PUCode,

CASE

...

Thanks Lowell, It's sorted now. the problem was mostly about the parentheses.

cheers