ok. Take two. Let me try again!

I wanted to get your opinion as to if this methodology will work for huge databases? I may have 12 million records in the...

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...