4 Replies Latest reply on Oct 14, 2016 10:54 AM by Dmitry Chirkov

    CustomeSQL error - Incorrect syntax near the keyword 'DECLARE'

    Hemant Tikyani

      Hello All,

       

      I'm trying to declaring few constant values in my queries like,

       

      DECLARE @ROTATION1S DATE = '2016-06-16';

       

      I get an error when I try to execute it from Tableau saying DECLARE " Incorrect syntax near the keyword 'DECLARE' ". Can we use the declare keyword in a custom sql?

       

      Any help would be appreciated.

       

      Thanks,

      Hemant