DECLARE 
	@ID int,
	@SID varchar(100),
	@NAME varchar(400),
	@BRAND varchar(10),
	@ARTIKUL varchar(100),
	@DESCRIPTION varchar(8000),
	@PRICE varchar(100),
	@PRESENT varchar(100),
	@LAST_MODEL varchar(250)
;

SET @LAST_MODEL = '';

DECLARE cPrice CURSOR LOCAL FOR
	Select
		ID,
		CAST(SID as varchar(100)),
		CAST(NAME as varchar(400)),
		CAST(BRAND as varchar(100)),
		CAST(ARTIKUL as varchar(100)),
		CAST(DESCRIPTION as varchar(8000)),
		IsNull(LTRIM(RTRIM(CAST(PRICE as varchar(100)))), ''),
		CAST(PRESENT as varchar(10))
	from #TMP_PRICE order by ID;

OPEN cPrice
FETCH NEXT FROM cPrice INTO @ID, @SID, @NAME, @BRAND, @ARTIKUL,
						@DESCRIPTION, @PRICE, @PRESENT;
WHILE (@@FETCH_STATUS <> -1)
BEGIN
	if (IsNull(@PRICE, '') = '' and IsNull(@NAME, '') <> '') 
	begin
		SET @LAST_MODEL = @NAME;
	end
	else
	begin
		update #TMP_PRICE set MODEL = @LAST_MODEL where ID = @ID;
	end;

	FETCH NEXT FROM cPrice INTO @ID, @SID, @NAME, @BRAND, @ARTIKUL,
							@DESCRIPTION, @PRICE, @PRESENT;
END
CLOSE cPrice;
DEALLOCATE cPrice;

delete from #TMP_PRICE where IsNumeric(CAST(PRICE as varchar(100))) = 0;