CROSS APPLY not supported
This error message is added when SnowConvert finds a CROSS APPLY. APPLY is not supported in Snowflake and the behavior of CROSS APPLY without it, is not the intended behavior that the original code had. For this reason, the entire CROSS APPLY statement is commented out.
SET some_row = A.another_row,
some_row2 = A.another_row/2
FROM some_table st
RIGHT JOIN some_table2 st2
(SELECT TOP 1 another_row FROM another_table at WHERE at.shared_id=st.shared_id) AS A;
SET some_row = A.another_row, some_row2 = A.another_row /2 FROM
-- ** MSC-ERROR - MSCEWI4019 - CROSS APPLY CLAUSE IS NOT SUPPORTED **
-- MYDB.PUBLIC.some_table st
--RIGHT JOIN MYDB.PUBLIC.some_table2 st2
-- (SELECT TOP 1 another_row FROM MYDB.PUBLIC.another_table at WHERE at.shared_id = st.shared_id) AS A
- No additional user actions are required, it is just informative.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.