3 Replies Latest reply: Oct 13, 2015 2:12 PM by Clever Anjos RSS

    Use a variable in sql select

    Matt Maino

      I set a variable at the beginning of my script, and I would like to assign this variable to every row of data in my sql select statement.

      The variable is called vTmp and this is how I am trying to incorporate it but it is not working.

       

      LOAN:

      SQL SELECT

          "Account_Phone",

          "Account_Type",

          "Risk_Raiting",

          $(vTmp)

      FROM "database".dbo."table";

       

      Is this technique possible?

       

      Thanks