bitbucket-25253 (1/7/2010)

---

You have posted your question in a SQL 2000 forum ... CROSS APPLY WAS introduced in SQL Server 2005 ...

For SQL 2000 CROSS JOINS exist and they exist...