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.
9 lines
359 B
9 lines
359 B
--unnötige Zeilen in Semestertabelle entfernen: |
|
delete from costage_st_semester where semester_tid not in ( |
|
select distinct semester from costage_st_studien_aggr) |
|
--aktuelles und Semester+1 ist immer drin: |
|
and not(today() between date(semester_anfang) and date(semester_ende)) |
|
and not(today()+185 between date(semester_anfang) and date(semester_ende)) |
|
|
|
; |
|
|
|
|