/build/static/layout/Breadcrumb_cap_w.png

Software Deployment Question


K1000: SQL variables

12/18/2014 3400 views
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

Comments

  • In my personal opinion the usage of the SET statement is not supported and will not work.
  • yes, it doesnt work for sure. i have desisted of the variables.thanks anyway!!

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ