HomeActive Query BuilderMS-SQL Server CROSS APPLY support

MS-SQL Server CROSS APPLY support


There is some plans to support CROSS APPLY of SQL Server. I have a customer wich need build some SQL query like theses listed below:

-- First example:
select c.Nome, v.MaiorValor
from Cliente c CROSS APPLY fnu_MaiorVenda(c.ClientePK) v
--
Source: http://sqlserver-brasil.blogspot.com/2008/08/t-sql-cross-apply.html


-- Second example:
select o.*, prev.*
from Order o
cross apply
(
select top 1 *
from Order P where P.OrderDate < O.OrderDate
order by OrderDate DESC
) prev
--
Source: http://weblogs.sqlteam.com/jeffs/archive/2007/10/18/sql-server-cross-apply.aspx

Do you plans to support this syntax in the future versions of AQB (VCL)?
Lourival O Silva | email
January 25 2010, 04:26 PM
This feature will be supported in the next minor version.
Sergey Smagin | email
2 days, 11 hours since original post
This topic is closed