20 lines
623 B
SQL
20 lines
623 B
SQL
INSERT INTO T_HAZIFELADATOK(C_FELADASDATUMA,C_HATARIDO,C_FELADATSZOVEGE,C_ORASZAM,C_ISTANARROGZITETTE,C_TANTARGYID,C_FELHASZNALOID,C_OSZTALYCSOPORTID,C_TANITASIORAID,C_INTEZMENYID,C_TANEVID,TOROLT,SERIAL,LASTCHANGED,CREATED)
|
|
SELECT t.C_DATUM
|
|
,DATEADD(week,1,t.C_DATUM) -- +1 het
|
|
,t.C_HAZIFELADAT
|
|
,t.C_ORASZAM
|
|
,'T'
|
|
,t.C_TANTARGYID
|
|
,ISNULL(t.C_HELYETTESITOTANARID,t.C_ORATULAJDONOSID)
|
|
,t.C_OSZTALYCSOPORTID
|
|
,t.ID
|
|
,t.C_INTEZMENYID
|
|
,t.C_TANEVID
|
|
,'F'
|
|
,0
|
|
,GETDATE()
|
|
,GETDATE()
|
|
FROM T_TANITASIORA AS t
|
|
WHERE t.C_HAZIFELADAT IS NOT NULL
|
|
AND t.C_HAZIFELADAT <> ''
|
|
AND t.TOROLT = 'F' |