on 07-09-2015 10:28 AM
Hello
I am facing a problem when writing HANA Procedures.
I am trying to use the SQL window function LEAD / LAG and PARTITION functions. But I am getting syntax errors on the same.
The same code ran successfully when I wrote in AMDP methods.
I believe the NATIVE SQL syntax should be same in AMDP or HANA Procedures. The code is given below. Please let me know where the things going wrong.
Below is the code -
Looks to me as if there's a closing bracket missing for the DAYS_BETWEEN function.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars
Thanks for your answer. But that was not for the Bracket missing, That code is now running fine.
But I am getting strange errors, While I am doing inner join with 2 tables its activating , but when I am using 3 tables in same select I am getting the error. My code and the error given below .
Could you plz help me out with troubleshoot.
Thanks in advance for the understanding.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.