It would be good if you can provide ,sample data and the function code.

Hi angjoni,

You can use below code to perform this operation:

create table test99 (column1 int, column2 int, result int)

insert into test99

values

(50,1500,0),

(100,0,0),

(40,0,0),

(30,0,0)

declare @col2 int = 1500

select * from test99

update test99

set @col2 =...