1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| MinMaxYear:
LOAD min(annee_sortie) as MinYear,
max(annee_sortie) as MaxYear
Resident FAIT_HOSPIT;
LET vMinYear = Peek('MinYear',0,'MinMaxYear');
LET vMaxYear = Peek('MaxYear',0,'MinMaxYear');
LET _i = $(vMinYear);
DO WHILE _i <= $(vMaxYear)
TempCalendrier:
LOAD
num(MakeDate($(_i),RecNo())) as DateID,
RecNo() as NumMois,
Month(MakeDate($(_i),RecNo())) AS Mois,
$(_i) AS Année
AutoGenerate 12;
LET _i = _i + 1;
LOOP
Calendrier:
LOAD
DateID as Date,
Month(MakeDate(Année,NumMois)) as Month,
Année as Year,
MonthName(DateID) as MonthName
Resident TempCalendrier;
DROP TABLE TempCalendrier;
DROP TABLE MinMaxYear; |
Partager