4 Replies Latest reply on Jan 7, 2013 7:24 PM by Nathan Krisanski

    How to put parameter in Custom SQL when creating Data Connection?

    rozvin.marchan

      Is it possible to put parameter in Custom SQL?

       

      Database: SQL Server 2005

       

      Fields:

      Brand

      Year

      ActualForMonth01~12 (e.g. ActualForMonth01 is the data for the month of January, ActualForMonth02 for February....)

       

      I would like to get the Actual value for the target month depending on the parameter.