3 Replies Latest reply: Aug 1, 2013 10:22 AM by Anton Gustle RSS

    SQL Load statement question

    Jennie Elliott

      I am trying to optimize qvd's and need to pull info from a SQL table but only transactions that are have an ID of 1 17. My code is below:


      SQL SELECT "DET_AcctID",
      FROM "databasename".dbo.Details
      WHERE "DET_TransTypeID"='1' and '17';

      Store * FROM TransactionDetails Into [C:\QlikView\QlikView Production\QVDocuments\SourceDocuments\QVD\VH2\TransactionDetails.csv] (txt);


      I have tried many variations to get it to pull only this data, I can get it to do 1 or 17 but not both of them together.


      Having a brain meltdown on this one...any help is much appreciated.