64 lines
1.2 KiB
SQL
64 lines
1.2 KiB
SQL
INSERT INTO dbo.T_DKT_FELADAT (
|
|
[C_BEADASHATARIDO]
|
|
,[C_DATUM]
|
|
,[C_FELADATERTEKELESTIPUSID]
|
|
,[C_FELADATTIPUSID]
|
|
,[C_IDOPONT]
|
|
,[C_INTEZMENYGUID]
|
|
,[C_ISAKTIV]
|
|
,[C_ISKRETAFELADAT]
|
|
,[C_ISLATHATO]
|
|
,[C_ISMODOSITHATO]
|
|
,[C_ISTOROLHETO]
|
|
,[C_LATHATOSAGIDOPONT]
|
|
,[C_ORARENDIORAGROUPID]
|
|
,[C_ORASZAM]
|
|
,[C_ROGZITESIDOPONT]
|
|
,[C_SZOVEG]
|
|
,[C_TANTARGYID]
|
|
,[C_OSZTALYCSOPORTID]
|
|
,[C_ALKALMAZOTTID]
|
|
,[C_TANITASIORAID]
|
|
,[C_HELYETTESITOALKALMAZOTTID]
|
|
,[C_ROGZITOALKALMAZOTTID]
|
|
,[C_INTEZMENYID]
|
|
,[C_TANEVID]
|
|
,[TOROLT]
|
|
,[LASTCHANGED]
|
|
,[CREATED]
|
|
)
|
|
SELECT
|
|
hf.C_HATARIDO
|
|
,ISNULL(tn.C_DATUM,C_FELADASDATUMA)
|
|
,0
|
|
,0
|
|
,hf.C_FELADASDATUMA
|
|
,i.C_GUID
|
|
,'T'
|
|
,'T'
|
|
,'T'
|
|
,'T'
|
|
,'T'
|
|
,hf.C_FELADASDATUMA
|
|
,oo.C_ORARENDIORAGROUPID
|
|
,hf.C_ORASZAM
|
|
,hf.C_FELADASDATUMA
|
|
,hf.C_FELADATSZOVEGE
|
|
,hf.C_TANTARGYID
|
|
,hf.C_OSZTALYCSOPORTID
|
|
,hf.C_ROGZITOID
|
|
,hf.C_TANITASIORAID
|
|
,hf.C_HELYETTESITOID
|
|
,hf.C_ROGZITOID
|
|
,hf.C_INTEZMENYID
|
|
,hf.C_TANEVID
|
|
,'F'
|
|
,hf.LASTCHANGED
|
|
,hf.CREATED
|
|
FROM T_HAZIFELADATOK hf
|
|
INNER JOIN T_INTEZMENY i on i.ID = hf.C_INTEZMENYID
|
|
INNER JOIN T_TANEV t on t.ID = hf.C_TANEVID AND t.C_AKTIV = 'T'
|
|
LEFT JOIN T_ORARENDIORA oo on oo.ID = hf.C_ORARENDIORAID
|
|
LEFT JOIN T_TANITASIORA tn on tn.ID = hf.C_TANITASIORAID
|
|
WHERE
|
|
hf.TOROLT = 'F' |