GilaMonster (8/27/2015)
We can't tune it if we can't see it.If you can;'t post it, then you're going to have to rewrite it yourself into the form of an in-line table valued function (a single select). If you can't, then the current performance will have to be accepted, as functions are notorious performance problems, and cursors in a function are just going to make it orders of magnitude worse.
Amen to all points Gail makes. There's nothing else to say.