Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
37 lines
729 B
37 lines
729 B
--costage_lehrveranstaltungen semesterweise füllen: |
|
|
|
delete from costage_lehrveranstaltungen |
|
where st_sem_nr in ( |
|
select distinct st_sem_nr |
|
from costage_lehrveranstaltungen_neu); |
|
|
|
insert into costage_lehrveranstaltungen(stp_sp_nr, |
|
ghk_nr, |
|
titel_de, |
|
titel_en, |
|
nummer, |
|
art_name_de, |
|
art_name_en, |
|
st_sem_nr, |
|
org_nr, |
|
sws, |
|
ects_credits, |
|
anerkennungsobjekt_flag, |
|
semester |
|
) |
|
select N.stp_sp_nr, |
|
N.ghk_nr, |
|
N.titel_de, |
|
N.titel_en, |
|
N.nummer, |
|
N.art_name_de, |
|
N.art_name_en, |
|
N.st_sem_nr, |
|
N.org_nr, |
|
N.sws, |
|
N.ects_credits, |
|
N.anerkennungsobjekt_flag, |
|
S.semester_tid |
|
FROM costage_lehrveranstaltungen_neu N, costage_st_semester S |
|
where S.st_sem_nr=N.st_sem_nr |
|
;
|
|
|