As a followup, it would be great if something like this worked...
SELECT TEST.a, t1.c, t1.idx
FROM TEST, dbo.f_StringToTable_2K_With_Index( TEST.s, '|' ) AS T1
It doesn't, I know.
I'm trying to avoid a loop through the table. That was the old approach written by a developer. Problem is it takes .25 seconds per row, and we have a 10+ K rows per table per db, ~12 tables in 20 db. And the window of processing time is very small.
Again, thankyou for your time and consideration.
Honor Super Omnia-
Jason Miller