how to store table into QVD file

[madhubabum]

Hi all

How can we store the .QVD file   <= '09/28/2014 date

Temp:

LOAD

    YearNumber,

    MonthText,

    WeekNumber,

    DateTimeCreated,

    date(floor(DateTimeCreated),'MM/DD/YYYY') as Date,

    DateTimeModified;

SQL SELECT YearNumber,

    MonthText,

    WeekNumber,

        DateTimeCreated,

    DateTimeModified

FROM Source

WHERE metricidentkey='{xxxxxxxxxxx}'

AND YearNumber >='2011';

Table2:

load *  Resident Temp

where Date <= '09/28/2014';

STORE Table2 INTO [Table2.qvd] (qvd);

[stephenedberkg]

store [TableName] into Path .qvd

ex

Store sales into D:\Sales.qvd