I have an extract script that brings data from my database and creates qvd tables. I have created a dashboard which has its own extract script. Data is brought in from the qvd tables and are presented in the dashboard.
The above script is in my extract script to create qvd tables.
I have a script that creates a table called spt_audit_event where I bring in the "Access_Date" field. I am trying to use the max function in the same script,but it gives me a script error.
However when I create another table doing a resident load from "spt_audit_event" table , the max function works.
But the problem I have is "SPT_AUDIT_EVENT" table is correlated with another table "inactive_autofire_users_report" . I am having trouble correlating this table with spt_audit_event2. Is there a way I can use the max function in the same script where I am bringing the extract date?
I know this sounds very confusing. I cant figure out how to insert a file . I was wanting to upload my script file. Hopefully I am making some sense for you to figure out what I need.