4 Replies Latest reply: Oct 26, 2016 11:48 AM by Marcus Sommer RSS

    How do I store several "LOADS" into a qvd-file?

    Søren Fabricius

      I have several loads from different tables and I want to store ALL data into a QVD-file

       

      When doing this I only store the first set of data (from : LOAD till l:FROM Kunder)

       

      Table_1:

      LOAD Bilag,

          KundeID,

         Fra,

         Til,

          Dannetden,

      Year(Dannetden) as Year_Dannetden,

      Month(Dannetden) as Month_Dannetden,

      Day(Dannetden) as Day_Dannetden,

          FakturaSum,

          FakturaSumDKR,

          CountPayUS;

      //    "upsize_ts";

      SQL SELECT *

      FROM Kunder.dbo.KundeBilag;

       

       

      LOAD SwitchboardID,

          ItemNumber,

          ItemText,

          Command,

          Argument;

      SQL SELECT *

      FROM Kunder.dbo."Switchboard Items";

       

       

      LOAD Valuta,

          Kurs;

      //    "upsize_ts";

      SQL SELECT *

      FROM Kunder.dbo.ValutaKurser;

       

       

      Store Tabel_1 into GammeltPODsystemStamData.qvd;