there is no stright way to find the max value in a row among the column.
see the following example ,to find the solution for ur problem.
replace the ur identity column with id column.
create table test2(id int identity(1,1),m ar1 decimal(15,3),m ar2 decimal(15,3),m ar3 decimal(15,3),r es decimal(15,3))
insert into test2 values(12.00, 11.00, 21.00,0)
insert into test2 values(11.00,...
Leave a comment: