All,

Thanks so much, I have taken a bit of all the answer to get all I need, i'm shamed to say when I have seen the response it...

I think this is a good post. Cursors are good when use right for the right process. But I have seen some when badly written help with the myth that...

Lowell, yes this is the way to go. I found when the compute is quite complex like

A int

B int

c int

D as A+B

E as ((A+B) / c) / A+B

F as...

This is a pain as it make the compute code massive in my case so I made them UDF like below

A

B

C = A+B

D = SumABX(A,B)

Function SumABX(A, B)

begin

...

I have tried this on a few severs now and on a few different version and still get 1,1

Is this right?