The Inline Function will be a LOT faster than a multi statement Function.

The reason you think the multi Statement Version is faster, is that in your Execution Plan the multi...

I'd probably go with something like this :

Select a.IDA, b.Status, b.IDB

from tblA a INNER JOIN tblB b on a.IDA = b.IDB

...

You are replacing the comma with an empty string, that will result in incorrect results even without running into the overflow.

have a look at the 2 examples below, that should...

It would help if you post the entire SP's code, but i would assume, that the table variable gets populated before the cursor gets opened.

The cursor gets populated by...