I am in the process of converting many Stored Procedures to UDFs (for various reasons).

One thing that is irritating is that these SPs often use the SELECT x, y, z INTO #tempTable pattern.

Would that be possible for you to generate the equivalent DECLARE @tempTable TABLE ( x TYPE,y TYPE,z TYPE) statement?

That would have proven to be very helpful!