Схема импорта предназначена для импорта прайс-листа с определением модели товара дополнительным SQL-скриптом.
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;
|