4 Replies Latest reply: Nov 28, 2011 1:55 PM by Dennis Hoogenboom RSS

    Set variable value.

         I have set the variable value in query editor.

       

      SET VarValue = 34;

       

       

      and also set this value in the sql where condition.

       

      select * from

      [AdventureWorksDW]

      [DimCurrency] 

      where  CurrencyyKey = $(VarValue);

       

       

      in the designer i used input text box to change the variable value  to populate  table box at the run time but its not changing. may i know where  i am doing wrong or i am missing some steps?