This content has been marked as final. Show 2 replies
I am new to QV.
I have 2 set of tables in SQL that get incremented counter added to name (each table average 55 933 802 records). I would like to generate .qvd file for each table.
Populate table with table names from DB
name as Names;
from sys.tables t
where name like 'Table0%';
Result for SQLTableList
Populate table with file names from QVData folder
For Each Ext In 'qvd' // filetype to search for in current directory
For Each File In FileList (Root & '\Table0*.' & Ext)
'$(File)' as Name
Result for QVDFileName
What I want is table with only the table names I have to generate QVD files for.
Result for GenQVD
I have investigated the following but did not find any examples where 3rd table is created from 2 existing tables:-
Where not exists
Any Ideas how to do the load for GenQVD?