delete from macro_feld_wert where macro=47060;

insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,10,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Semester'' order by 2',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,10,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Geschlecht'' order by 2',1);

insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,20,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Semester'' order by 2',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,20,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Nationalität'' order by 2',1);

insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,30,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Hochschule'' order by 2',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,30,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Geschlecht'' order by 2',1);


insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,40,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Hochschule'' order by 2',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,40,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Nationalität'' order by 2',1);

insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,10,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,20,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,30,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1);
insert into macro_feld_wert (macro, sortnr, feldname, value, active)
values (47060,40,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1);