Hello, I have the following function that connects to the DB and runs a query that should return a single user name. The problem is that the query works in SQL but does not return a value when...
Indeed, SQL providers issued before SQL 2005 don't support the CROSS and OUTER APPLY operators. To be able to use these keywords, you need to connect to the database using a newer version of the SQL provider that supports SQL 2005 syntax.