SQL - EAN
Contents
FAQ - úprava váhových EANů v číselníku EANů a zboží
Vety v CK s vahovym EANem 24/27/28/29
SELECT
*
FROM
(
SELECT
SUBSTRING(Cislo32 FROM 1 FOR 2) AS EAN2,
Cislo32,
Cislo,
Nazev
FROM
A5__CK00
) AS A1
WHERE
(EAN2='24') OR
(EAN2='27') OR
(EAN2='28') OR
(EAN2='29')
Vety v Z s vahovym EANem 24/27/28/29
SELECT
*
FROM
(
SELECT
SUBSTRING(CarkovyKod FROM 1 FOR 2) AS EAN2,
CarkovyKod,
Cislo,
Nazev,
INT32_01
FROM
A5__Z201
) AS A1
WHERE
(EAN2='24') OR
(EAN2='27') OR
(EAN2='28') OR
(EAN2='29')
CK - pro vahove EANy 24/27/28/29 zkraceni EANu na levych 6 mist
UPDATE
A5__CK00
SET
Cislo32=SUBSTRING(Cislo32 FROM 1 FOR 6)
WHERE
(SUBSTRING(Cislo32 FROM 1 FOR 2)='24') OR
(SUBSTRING(Cislo32 FROM 1 FOR 2)='27') OR
(SUBSTRING(Cislo32 FROM 1 FOR 2)='28') OR
(SUBSTRING(Cislo32 FROM 1 FOR 2)='29')
Z - pro vahove EANy 24/27/28/29 zkraceni EANu na levych 6 mist
UPDATE
A5__Z201
SET
CarkovyKod=SUBSTRING(CarkovyKod FROM 1 FOR 6)
WHERE
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='24') OR
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='27') OR
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='28') OR
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='29')
Z - pro vahove EANy 24/27/28/29 nastaveni INT32_01=1 (cislo vahy)
UPDATE
A5__Z201
SET
INT32_01=1
WHERE
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='24') OR
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='27') OR
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='28') OR
(SUBSTRING(CarkovyKod FROM 1 FOR 2)='29')