Outer Apply and Sql View

[neoklis]

Hi all,

I have a SQL view with the below statement..

SELECT *
FROM PERF_Performance AS Perf OUTER Apply dbo.perf_calc(Perf.WCID, Perf.Material_Group, Perf.MRP_Controller, Perf.Description, Perf.Component_Flag,
Perf. D, Perf.Length, Perf.Operators, Perf.Analosi_Takin_mtr, Perf.Machtime, Perf.QMTR, Perf.Qkg, perf.qst, perf.Pieceweight, perf.wtub, Perf.Coilheight,
Perf.s) AS Calc
WHERE perf.wcid = '10000721'

When I click to modify the view I get a message saying ‘The OUTER APPLY SQL construct or statement is not supported.’ When I click execute the view is running great. Is something I should be worried about? Do i have to use something else similar to Outer Apply? The problem appears only when I use the Sql statement in a view..

Thank you

 

[SQL_Hell]

Hi,

There are certain limitations as to what functions you can use in a view, try putting it in a stored procedure and see if it works that way.