14 lines
256 B
SQL
14 lines
256 B
SQL
INSERT INTO T_TANTARGYNYELV (C_NEV, C_NYELVID, C_TANTARGYID, C_INTEZMENYID, C_TANEVID, CREATED, CREATOR)
|
|
SELECT
|
|
C_NEMETNEV
|
|
,507 --NÉMET
|
|
,ID
|
|
,C_INTEZMENYID
|
|
,C_TANEVID
|
|
,GETDATE()
|
|
,0
|
|
FROM T_TANTARGY
|
|
WHERE
|
|
C_NEMETNEV IS NOT NULL
|
|
AND TOROLT = 'F'
|