9 Replies Latest reply: Sep 1, 2016 3:46 AM by Richard Chilvers RSS

    SQL where operator

    Андрей Шепель

      Good day!

      Colleagues, is any way in QV script of using QV variable in SQL query ?

       

      For example:

      1. Current Load

       

      Main:

      Load

      Period;

      SQL SELECT *

      FROM DataBase.dbo.DP3_Sales_Fact with (nolock)

      where Period>='2016-08-01 00:00:00.000';

       

      2.Neccessary Load

      Main

      Load

      Period;

      SQL SELECT *

      FROM DataBase.dbo.DP3_Sales_Fact with (nolock)

      where Period>=Current YearMonth;

       

      In other words, in sql query i need load only Period for Current YearMonth (201608)

      Thanks.