Yes, I got it.

I think I over-engineered it.

I am going to scrap all that and create one SQLCLR which accepts set of parameters, queries the table and hands over the...

I think I should have been more clear with what I am trying to do.

Overall this is what happens:

1. Execute a SP get result set back - this has all...