|
Archives of the TeradataForumMessage Posted: Mon, 18 May 2009 @ 09:29:38 GMT
Hi, I am using Macro to write some complex data manipulation. I need local variable in Macro to store intermediate values. Can any one give me syntax. I am getting error when I use Procedure syntax. Declare localvarb char(10); 2. Can we able to use select statement inside between like below Select * from testdb.emp where deptno between (select max(deptno) from testdb.dept) and 10 It throws below error. 3706: Syntax error: expected something between '(' and Select keyword. Regards, Kumar.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||