I just wonder if using UDF is better than using a SP on the linked server. The SP would return a rowset, of course, that would be inserted into a local temp table. OR use a UDF and still insert into a local temp temp for further usage.
So, does anyone have experience of comparing performance of these approaches?
Thank you.
Michael