Now that I have tried to use a UDF that returns a table variable, I hit this wall:

"Only functions and extended stored procedures can be executed from within a function."

Inside of this what was originally to be a stored procedure, I dynamically need to execute DML's inside using sp_executesql <String variable>. Well this is a limitation of a UDF that I have run into.

So after all of this, what I have learned is that with all this new "table' type variable you can only do somethings in certain situations. So it looks like I will now go back to the "old standby"; stored procedure that returns a select statement and pass it to a temp. table in the calling stored procedure!