Although the "GetNums" function would indeed make this simpler in-line, it simply moves the complexity to another routine. Combined, the two parts have nearly the same code.

That having...

Duh - The "Into @tab" is not using the Select, but instead the output, which does include two columns.

Select * into a table (or Output *...

My problem is that I expected that "inserted" would be a complete copy of the inserted row (I haven't used OUTPUT, but triggers certainly work that way). As such,...

I selected "Returns an error". It didn't seem right, but I'm not sure why the following code works

INSERT TestTable (string)

OUTPUT inserted.*

Doesn't the select return more columns (ID and String)...

After lots of research (and many dead-ends), the solution is to "Alter database FOO Set Trustworthy ON"

It does not seem to be necessary to make BAR Trustworthy as well.

Of course,...