1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| create table test (Information char(11), Date datetime, Solde tinyint, Date_paiement datetime)
;With MaTable (Information, Date, Solde, Date_paiement) as
(
select 'tototottoto', cast('2011-07-01' as datetime), 0, cast( NULL as datetime) union all
select 'tototototot', cast('2011-07-08' as datetime), 1, cast('2011-07-30' as datetime) union all
select 'tototototot', cast('2011-07-04' as datetime), 1, cast('2011-08-11' as datetime) union all
select 'tototototto', cast('2011-07-16' as datetime), 0, cast( NULL as datetime)
)
insert into test
select mt1.Information, mt1.Date, mt1.Solde, mt1.Date_paiement
from MaTable as mt1
cross join MaTable as mt2
cross join MaTable as mt3
cross join MaTable as mt4
cross join MaTable as mt5
cross join MaTable as mt6
cross join MaTable as mt7
cross join MaTable as mt8
cross join MaTable as mt9
cross join MaTable as mt10
cross join MaTable as mt11 |
Partager