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