Most of them can be changed dynamically while the server is running using SET GLOBAL or SET SESSION: - Syntax to Set value to a Global variable: SELECT can be set at server startup using options on the command line or in an option file. To see the current values used by a running server, use the SHOW VARIABLES statement or SELECT SHOW VARIABLES LIKE '%wait_timeout%' Global variables affect the overall operation of the server whereas session variables affect its operation for individual client connections. They can be of type GLOBAL, SESSION or BOTH. Server System Variables (prefixed with MySQL server maintains many system variables configured to a default value. The scope of a local variable is the BEGIN. If the DEFAULT clause is missing, the initial value is NULL. SELECT * FROM places WHERE place BETWEEN start AND finish They can be used as local variables and the input parameters Local variables needs to be declared using DECLARE before They can be used in SELECT queries using Advanced MySQL user variable techniques.

Variable defined by one client cannot be seen or used by other User-defined variables are session-specific. Types: integer, decimal, floating-point, binary or nonbinary string, SELECT * FROM places WHERE place BETWEEN AND variables can be assigned a value from a limited set of data SELECT can initialize a variable using SET or SELECT statement: SET = 1, = 10 Initialized, it has a value of NULL and a type of string. If you refer to a variable that has not been User-defined variables (prefixed with can access any user-defined variable without declaring it or SET MoneyFormat ='€ #.#0,00 € -#.There are mainly three types of variables in MySQL: It is possible to make vtFromDate and vToDate changeable.

Thanks, it worked : This is my current script: It is much more simpified, but it works. 'name database'.dbo.'SDC_CHANGETYPE' C ON CDPOS.CHNGIND = C.CHNGIND 'name database'.dbo.'SDC_CUST' BS ON EKKO.COMPANYCODE = BS.COMPANYCODE AND BS.CUSTOMTYPE = 'BSART' AND BS.CUSTOMKEY = EKKO.BSART LEFT JOIN 'name database'.dbo.'SDC_CUST' FNAME ON SEL.COMPANYCODE = FNAME.COMPANYCODE AND FNAME.CUSTOMTYPE = 'ROLLNAME' AND FNAME.CUSTOMKEY = CDPOS.FNAME LEFT JOIN 'name database'.dbo.'SDC_CUST' TNAME ON SEL.COMPANYCODE = TNAME.COMPANYCODE AND TNAME.CUSTOMTYPE = 'TABNAME' AND TNAME.CUSTOMKEY = CDPOS.TABNAME LEFT JOIN SEL.OBJECTID = CDPOS.OBJECTID AND SEL.CHANGENR = CDPOS.CHANGENR LEFT JOIN

'name database'.dbo.'SDC_CDPOS' CDPOS ON SEL.COMPANYCODE = CDPOS.COMPANYCODE AND SEL.OBJECTCLAS = CDPOS.OBJECTCLAS AND 'name database'.dbo.'SDC_EKKO' EKKO ON SEL.COMPANYCODE = EKKO.COMPANYCODE ANDĮKKO.EBELN = SEL.OBJECTID AND SEL.OBJECTCLAS = 'EINKBELEG' INNER JOIN 'name database'.dbo.'SDC_CDHDR' SEL INNER JOIN BS.DESCRIPTION AS DOCUMENT_TYPE_DESCRIPTION,ĬASE WHEN DATEADD(MM, -1, SEL.UDATE) < EKKO.AEDAT THEN 'WITHIN 1 MONTH' ELSE 'OVER ONE MONTH' END AS CHANGE_DELAY,

Declare sql varibale in qlik sense