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
| CREATE TABLE dbo.Commande
(
Code_Article varchar(10)
, Date_Commande date
, Prix decimal(5,2)
)
INSERT INTO dbo.Commande (Code_Article, Date_Commande, Prix)
select 'LEGUME', convert(date, '01/01/2012', 103), 10 union all
select 'LEGUME', convert(date, '01/06/2011', 103), 10 union all
select 'LEGUME', convert(date, '01/01/2012', 103), 10 union all
select 'LEGUME', convert(date, '01/01/2012', 103), 10 union all
select 'LEGUME', convert(date, '01/06/2010', 103), 10 union all
select 'LEGUME', convert(date, '01/06/2009', 103), 10
CREATE TABLE dbo.Article_Cout_Histo
(
Code_Article varchar(10)
, Date_Depart_Cout date
, Cout decimal(5,2)
)
INSERT INTO dbo.Article_Cout_Histo (Code_Article, Date_Depart_Cout, Cout)
select 'LEGUME', convert(date, '01/01/2012', 103), 1.15 union all
select 'LEGUME', convert(date, '01/01/2011', 103), 1.10 union all
select 'LEGUME', convert(date, '01/01/2010', 103), 1.05 union all
select 'LEGUME', convert(date, '01/01/2009', 103), 0.99 |
Partager