Christopher Kutsch (9/12/2014)
tempdb is always going to run under the native compatibility mode. Add a Use tempdb statement before you call the CROSS APPLY and change the context back when done.
Note that this is a 5 year old thread.
Your suggestion might be questionable.