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
|
INSERT INTO tbl_periodes ( DtAnMois )
SELECT tbper.anms
FROM (
SELECT DateSerial(Year(Now()),1,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),2,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),3,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),4,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),5,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),6,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),7,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),8,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),9,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),10,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),11,1) AS anms FROM MSysObjects WHERE Type=2
union
SELECT DateSerial(Year(Now()),12,1) AS anms FROM MSysObjects WHERE Type=2) AS tbper
WHERE (tbper.anms) Not In (select dtanmois from tbl_periodes); |
Partager