I’m trying to tune a stored procedure that has outer apply and cross apply in it and I am getting the invalid SQL statement message. When I take the apply statements out it works fine. Can the optimizer do apply statements?
Thank you very much for interest in our product. Both CROSS and OUTER APPLY will be supported in 7.5 as well as some of other new 2008R2 syntaxs. Will will start another beta program later. So please stay tuned on our new beta announcement later
All the Best,