Ok, does any know if/ifnot/how table-type udf's could be joined as part of another query?
Like:
select a.*,b.*
from mytable a, fn_myFunction(a.FK_ID) b
where (a.PK_ID=1)
My issue is (I think) that I'm relying on data extracted from the outer query to power the UDF. Anyway, I can't figure this out, so I thought I'd ask.