40 lines
991 B
Transact-SQL
40 lines
991 B
Transact-SQL
INSERT INTO T_DASHBOARDUZENETFELHASZNALO (
|
|
C_MEGJELENITESEKSZAMA
|
|
,C_UTOLSOMEGTEKINTESIDEJE
|
|
,C_EGYEDIMUVELET
|
|
,C_DASHBOARDUZENETID
|
|
,C_FELHASZNALOID
|
|
,C_INTEZMENYID
|
|
,C_TANEVID
|
|
,TOROLT
|
|
,SERIAL
|
|
,LASTCHANGED
|
|
,CREATED
|
|
,MODIFIER
|
|
,CREATOR
|
|
,ELOZOTANEVIREKORDID
|
|
,NNID
|
|
) SELECT
|
|
CASE WHEN up.C_ISPOPUPMEGJELENITES = 'T' THEN 1 ELSE 0 END AS C_MEGJELENITESEKSZAMA
|
|
,NULL AS C_UTOLSOMEGTEKINTESIDEJE
|
|
,NULL AS C_EGYEDIMUVELET
|
|
,d.ID AS C_DASHBOARDUZENETID
|
|
,f.ID AS C_FELHASZNALOID
|
|
,f.C_INTEZMENYID AS C_INTEZMENYID
|
|
,f.C_TANEVID AS C_TANEVID
|
|
,'F' AS TOROLT
|
|
,0 AS SERIAL
|
|
,GETDATE() AS LASTCHANGED
|
|
,GETDATE() AS CREATED
|
|
,NULL AS MODIFIER
|
|
,NULL AS CREATOR
|
|
,NULL AS ELOZOTANEVIREKORDID
|
|
,NULL AS NNID
|
|
FROM T_MUNKAUGYIADATOK m
|
|
INNER JOIN T_FELHASZNALO f ON f.ID = m.C_ALKALMAZOTTID
|
|
INNER JOIN T_USERPROFILE up ON up.C_FELHASZNALOID = m.C_ALKALMAZOTTID
|
|
INNER JOIN T_DASHBOARDUZENET d ON d.C_EGYEDIAZONOSITO = 'POPUPKKEFOP324'
|
|
WHERE
|
|
f.TOROLT = 'F'
|
|
AND m.C_EFOP324PROJEKT = 'T'
|
|
GO |