24 lines
1.0 KiB
Transact-SQL
24 lines
1.0 KiB
Transact-SQL
--Migration
|
|
----------------------------
|
|
DECLARE @feltarASZFUrl nvarchar(255) = 'https://tudasbazis.ekreta.hu/download/attachments/75104744/Eszkozigenyles_Pedagogus_ASZF.docx?api=v2'
|
|
|
|
UPDATE intezmenyconfig
|
|
SET C_ERTEK = @feltarASZFUrl
|
|
FROM T_INTEZMENYCONFIG intezmenyconfig
|
|
INNER JOIN T_INTEZMENY intezmeny ON
|
|
intezmeny.ID = intezmenyconfig.C_INTEZMENYID
|
|
AND intezmeny.TOROLT = 'F'
|
|
WHERE intezmenyconfig.C_CONFIGTIPUSID = 28
|
|
AND intezmenyconfig.TOROLT = 'F'
|
|
|
|
----------------------------
|
|
DECLARE @feltarASZFGondviseloUrl nvarchar(255) = 'https://tudasbazis.ekreta.hu/download/attachments/75104744/Eszkozigenyles_Gondviselo_ASZF.docx?api=v2'
|
|
|
|
UPDATE intezmenyconfig
|
|
SET C_ERTEK = @feltarASZFGondviseloUrl
|
|
FROM T_INTEZMENYCONFIG intezmenyconfig
|
|
INNER JOIN T_INTEZMENY intezmeny ON
|
|
intezmeny.ID = intezmenyconfig.C_INTEZMENYID
|
|
AND intezmeny.TOROLT = 'F'
|
|
WHERE intezmenyconfig.C_CONFIGTIPUSID = 31
|
|
AND intezmenyconfig.TOROLT = 'F' |