Sometimes the best choice is to throw everything away and start over.

>Seems this is related to the XML question you asked a week or so ago and you got a lot of feedback that for passing in information as parameters XML was a very bad choice when a structure (or for that matter something in json) would be much easier to work with and debug.
>
>There was also talk of moving this to the backend where you could leverage your Tsql skills and use things like TVPs.
>
>This is what I meant about design assumptions. XML and processing things in the middle tier might be exactly where it all went wrong to begin with and now by sticking with those decisions you may be locked into fighting this thing all the way.