DROP table IF EXISTS #list_of_subgroup_name
SELECT DISTINCT subgroup_name
INTO #list_of_subgroup_name
FROM table

SET @max_number_of_subgroup = (SELECT
max(right(subgroup_name, len(subgroup_name) - (patindex('%подгруппа%',subgroup_name)+8))) AS [number_of_subgroup] FROM #list_of_subgroup_name)



SET @text_of_subgroup = (SELECT distinct left(subgroup_name, patindex('%подгруппа%',subgroup_name)+8)
FROM #list_of_subgroup_name WHERE subgroup_name = @subgroup_name_ctr)

SET @lowest = (select min(cost) from table WHERE subgroup_name = @subgroup_name_ctr)
set @delimiter = @lowest


WHILE (SELECT count(cost) FROM table WHERE cost > @lowest AND subgroup_name = @subgroup_name_ctr) > 0
begin


update table
set new_subgroup_name = concat(@text_of_subgroup, @max_number_of_subgroup+1)
where unit_cost_within_part >= @previous_lowest AND unit_cost_within_part < @lowest AND subgroup_name = @subgroup_name_ctr

set @delimiter = @lowest*1.15

SET @max_number_of_subgroup = @max_number_of_subgroup+1

SET @previous_lowest = @lowest

set @lowest = (select min(cost)
from table
where @delimiter <= cost AND subgroup_name = @subgroup_name_ctr)
end