Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi
May be like this
[QVD1]:
LOAD *;
SQL EXEC [dbo].[usp_QVD1];
LEFT JOIN
LOAD *;
SQL EXEC [dbo].[usp_QVD2];
STORE [QVD1] INTO qvd1.qvd;
Regards,
Andrey
Hi
May be like this
[QVD1]:
LOAD *;
SQL EXEC [dbo].[usp_QVD1];
LEFT JOIN
LOAD *;
SQL EXEC [dbo].[usp_QVD2];
STORE [QVD1] INTO qvd1.qvd;
Regards,
Andrey
WOW! It worked! Thanks!...
BTW, Just to tickle my mind... what happened if I add or I have another QVD? Let's say 'QVD3'?
Does my script would be like this?
[TOTALQVD]:
LOAD *;
FROM totalqvd.qvd(qvd);
LEFT JOIN
LOAD *;
SQL EXEC [dbo].[usp_QVD3];
STORE [TOTALQVD] INTO totalqvd2.qvd;
I hope I'm right
Yes, you are right, if in QVD3 there is also only one coinciding field [FieldKey] and other fields have different names from QVD1, QVD2.
thanks!