Automating a QVD fle

[#1]

Hi,

I have a query which I run and it creates a QVD file.

In the opening statement I have

OLEDB Connect TO ........

Test_date:

Query Statement 1

-----------------------

-----------------------

STORE  Test_date into Test_date.qvd

Drop table Test_date;

Here I would like to know if there is anyway I can rename the date from Test_date to a actual date.

As I want to run this every day and want the date change with todays date.

Thanks-

[luciancotea]

SET vName = date(Today(), 'YYYYMMDD');

OLEDB Connect TO ........

Test_date:

Query Statement 1

-----------------------

-----------------------

STORE  Test_date into $(vName).qvd

Drop table Test_date;

[#3]

how to make monthly report replacing jan by M1.....DEC BY M12

I HAVE COME TO THIS POINT IN MY SCRIPT

OrderID,

     CustomerID,

     EmployeeID,

     OrderDate,

     Year(OrderDate) as Year,

     Month(OrderDate) as Month,

     'Q' & Ceil(Month(OrderDate)/3) as Quarter,

     Dual('Q' & Ceil(Month(OrderDate)/3) & '-' & Year(OrderDate),

     Year(OrderDate) & Ceil(Month(OrderDate)/3)) as QtrYear,