4 Replies Latest reply: Aug 15, 2017 3:17 AM by Kevin Somosera RSS

    2 Existing QVD to Generate 1 QVD

    Kevin Somosera

      Hi,

       

      I just need some help on working with QVD's. Here's my scenario...

       

      I create 1 QVW that generate 2 QVD's (Let's Say 'QVD1' and 'QVD2'). Now, I want them to merge into a single QVD ('TOTALQVD').

      Now QVD1 and QVD2 has a connecting Fields(Let's call it FieldKey) Now, Can you help me how I can generate "TOTALQVD" and use it my other reports?

       

      Here's how I generate the two QVD's:

      [QVD1]:

      LOAD *;

      SQL EXEC [dbo].[usp_QVD1];

      STORE [QVD1] INTO qvd1.qvd;

       

      [QVD2]:

      LOAD *;

      SQL EXEC [dbo].[usp_QVD2];

      STORE [QVD2] INTO qvd2.qvd;

       

      Can you help me how I can add a script to combine these two QVD's?

      THANKS!