Hello, mcastro171164!

Saturday, January 7, 2012, 4:45:48 PM, you wrote:

m> This code is generated by the Dot.Net provider
m> FirebirdSql.Data.FirebirdClient.dll.

Are you sure that Firebird .Net Provider (!)
generates SQL, and moreover, it generates sql
incompatible (!) with Firebird?

for example, the file FirebirdSql.Data.FirebirdClient.dll does not
contain sql keyword APPLY at all.
As you were told by Lester Caine, you use some tool that
generates SQL for MS SQL server, not for Firebird.

--
Dmitry Kuzmenko, www.ib-aid.com