1 Reply Latest reply: Jun 15, 2012 12:46 PM by Victor Salesa Sanz RSS

    SQL Load

    Hardik Gandhi

      Hi,

       

      I am trying to create a QVD file through a SQL statement. But its giving an error that table not found.

       

      Message_Log1:

       

      SQL Select PersonID, Count((convert(varchar(10),[CreateDate],111)) )

      From dbo.Message

      Where ActivityType=8 AND

      convert(varchar(10),[CreateDate],111) >= '2011/01/01'

      Group by PersonID, convert(varchar(10),[CreateDate],111);

       

      Store Message_Log1 into \\Portal QVD Data\Message_Log1.qvd;

       

      Drop Table Message_Log1;

       

      Thanks,

      H