1 Reply Latest reply on Nov 11, 2006 8:56 AM by PaulKD

    Dynamic Variable Naming Help

      I have a SQL INSERT statement that has the following:


      but currentyear is actually a variable, a LIST specifically:

      so I need the statement in the SQL query
      to evaluate #QueryData.JAN_2003#
      and on next loop to #QueryData.FEB_2003# and so on

      how can I specify that "currentyear" is a variable?

      thanks in advance