Grant, i have all these proc because all of then return a different thing.... let me try to give you guys a more wide view...

This table vw_associacao, and their deriveted...

First time i execute the procedure, i dont pass any parameter, so the function arent called... the procedure returns in 5 seconds, second time i execute it took just one...

You mean, if i make the split in the code instead of calling the function? What about reuse of code?

This is actually this functions.. i have found it in the...