2 Replies Latest reply: May 8, 2017 3:17 AM by Peter Rieper RSS

    Generating Multiple Qvd

    Sunilkumar Yadav

      Hi ,

      Thanks in advance!!!!

       

      My requirement is that i have two variable vStartDate And vEndate,

      For example I have pass date to these variables vStartDate = 04-05-2017 and vEndate = 08-05-2017.

      and my query is

       

      $(vTableName):
      SQL
      SELECT * FROM
      $(vTableName)

      where DAY_KEY >= $(vStartDate)
      and DAY_KEY <=
      $(vEndDate);


      and it should store the data for each day in diffrent qvd for example:

      $(vTableName)_04-05-2017.qvd

      $(vTableName)_05-05-2017.qvd

      $(vTableName)_06-05-2017.qvd

      $(vTableName)_07-05-2017.qvd

      $(vTableName)_08-05-2017.qvd;