SQL-запрос экспорт с изменениями будет выглядеть так:
Код
SELECT
REPLACE(gr.GR_FULL_NAME, '\', '/') as "Категория",
g.G_NAME as "Товар",
LTRIM(REPLACE(STR(g.price, 10, 2), ',', '.')) as "Цена",
'' as "Адрес",
CASE WHEN g.G_ACTIVE = 1 THEN '1' ELSE '0' END as "Видим",
CASE WHEN g.G_RECOMEND = 1 THEN '1' ELSE '0' END as "Рекомендуемый",
(SELECT b.B_NAME FROM TBL_BRANDS b WHERE b.B_ID = g.G_B_ID) as "Бренд",
'' as "Вариант",
'' as "Старая цена",
g.G_SID as "Артикул",
g.G_REST as "Склад",
g.G_NAME as "Заголовок страницы",
g.G_NAME as "Ключевые слова",
g.G_DESC as "Описание страницы",
g.G_DESC as "Аннотация",
ISNULL(CAST(g.G_DESC_FULL as varchar(max)), '') + ' ' + ISNULL(g.G_URL, '') as "Описание",
g.G_PICTURE as "Изображения"
FROM TBL_GOODS g, TBL_GROUPS gr
WHERE g.G_GR_ID = gr.GR_ID
|
