11 Replies Latest reply: Oct 9, 2013 5:19 AM by Tresesco B RSS

    How to use Variable in Where Clause

      Hello All,

       

      Need your help very urgent.

      i have a something like below,

       

      Load

      Week

      From ABC.QVD;

       

      vWeek=max(Week)

       

      Sellout:

      Load *

      From XYZ.QVD where Week<=$(vWeek);

       

      When i run the above script, it says field not found.

       

      Need your help on how to use variable in Where clause.

       

      Thanks for your help

       

      Thanks & Regards,

      Venkat T