Are you executing the code on a SQL 2005? Does not work on SQL 2000.

Here is the link for more information on CROSS APPLY

http://msdn.microsoft.com/en-us/library/ms177634.aspx

Rudy