Tag: sap

How we can validate/identified two SQL queries whether data is matching from both the queries output or not in SAP HANA Studio?

I have a question, can anyone help me with this? I have two SQL queries, one is query on top of reporting calculation view and the other is a query on the base CV of reported CV. Now, I need to …

SQL “IS NOT NULL” compensation for SAP HANA SQLScript

hana isnull sap sql

Actually I tried to run a is null SQL Statement on a SAP HANA Database using the SAP HANA Studio. This does not work because SQLScript has no is not null or is null function. My statement looks like: Unfortunately it does not work. Does anybody know an alternative approach which is practicable using SAP HANA SQLScript? On the internet