declare @eff table (id int identity(1,1), data decimal(18,2)) --insert into @eff('6.78') insert @eff(data) values (6.78) --,(15.70) select * from @eff declare @eff2 table (id int identity(1,1),data decimal(18,2)) declare @temp2 decimal (18,2) declare @i int set @i=1 while((select count (data) from @eff) >=@i) begin if((select PARSENAME(data,1) from @eff where id = @i ) > 59 ) begin set @temp2 = ((select data - (0.60)+convert(decimal(18,2),'.'+(convert(varchar(20),PARSENAME( data,1)))) from @eff where id = @i)) print @temp2 insert @eff2 (data) values (@temp2) print @temp2 end set @i=@i+1 end select * from @eff2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)