Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
First test the SQL statement syntax is correct.
Second try to store the qvd locally in a path like c:/
Your problem looks like the table hasnt been loaded into qlikview before the store statement.