|
|
|
|
|
|
|
|
|
|
Re: Single update to get one column value using another column value [message #679356 is a reply to message #679348] |
Tue, 25 February 2020 05:50 |
John Watson
Messages: 8935 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
sss111ind wrote on Tue, 25 February 2020 10:18Thanks for reply,
Actually in place of sal+10 , I am using a function and there is 3 function call. And instead of update we are using merge statement. So I want to call the function one time for each row. Is there any way to achieve this.
Even if the function is called several times, you can prevent it being executed several times by declaring the RETURN as DETERMINISTIC. Or better still, if you have EE licences you could enable the function result cache which would let one execution be shared across statements and sessions.
|
|
|
|
|