K1000: SQL variables
I was trying to do exactly the same as bostonbound in http://www.itninja.com/question/mysql-user-defined-variables, using variables in a kace´s report. But it gives errors (just in Kace, not in MySQL).
so im just looking for confirmation, is it still not possible to use variables in Kace??
example:
SET @DataInicial = '2014-12-10';
SET @DataFinal = '2014-12-13';
select U.FULL_NAME AS ATENDENTE, HD_QUEUE.NAME AS FILA, @DataInicial as DataInicial,@DataFinal as DataFinal
.......
2 Comments
[ + ] Show comments
-
In my personal opinion the usage of the SET statement is not supported and will not work. - StockTrader 10 years ago
-
yes, it doesnt work for sure. i have desisted of the variables.thanks anyway!! - Paloma 10 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
