--le but de ce script est d'extraire les données simulées à chaque année et les importer dans des tables SQL

declare @year, @tab, @tab2;

set @year = 101;

--boucle pour chaque année simulée  (de 101 à 700)

while @year <= 700

begin
   SET @tab = 'sites' + CAST (@year AS STRING); -- Casts @I
   SET @tab2 =  CAST (@year AS STRING); -- Casts @I
   
   --créer un table pour chaque année
   
   CREATE TABLE  @tab (

"Time" double precision, 
"Simulation"double precision, 
"Id"double precision, 
"Xmodel"double precision, 
"Ymodel"double precision, 
"NbPersons"double precision, 
"NbFamilies"double precision, 
"NbHouseholds"double precision, 	
"TimeStart"double precision, 
"TimeEnd"double precision, 
"05Living"double precision, 
"05dead"double precision, 
"05sent"double precision, 
"05received"double precision, 
"515Living"double precision, 
"515dead"double precision, 
"515sent"double precision, 
"515received"double precision, 
"1517Living"double precision, 
"1517dead"double precision, 
"1517sent"double precision, 
"1517received"double precision, 
"1725Living"double precision, 
"1725dead"double precision, 
"1725sent"double precision, 
"1725received"double precision, 
"25+Living"double precision, 
"25+dead"double precision, 
"60-Living"double precision, 
"60-dead"double precision, 
"60-sent"double precision, 
"60-received"double precision, 
"60+Living"double precision, 
"60+dead"double precision, 
"60+sent"double precision, 
"60+received"double precision, 
"EntryMales"double precision, 
"EntryFemales"double precision, 
"OutputMales"double precision, 
"OutputFemales"double precision, 
"IdScissionFrom"double precision, 
"NbBovins"double precision, 
"NbCaprins"double precision, 
"NbPorcins"double precision, 
"GainsBovins"double precision, 
"GainsCaprins"double precision, 
"GainsPorcins"double precision, 
"Hunting"double precision, 
"Picking"double precision, 
"Seed"double precision, 
"NetCrop"double precision

)
WITH (
  OIDS=FALSE
   );

--extraire les données simulées pour chaque année et les importer dans la table

COPY @tab FROM 'D:\obresocBEAN301115\Release\Simulation49\Sites@tab2\OutputHouseLTime@tab2.csv' WITH DELIMITER ',' CSV HEADER;

   SET @year = @year + 1;
END