My understanding of SQL is that is the same as But I’m getting completely different ResultSets when the only difference in the queries is the date range specification. The correct dates are being returned but the data is different. This is happening in both Teradata and HANA. Am I missing something? EDIT: AS POINTED OUT THIS IS THE RESULT OF
Tag: hana-sql-script
SQL: SAP Hana if parameter is null, ignore where
I’m passing 3 parameters into my Hana Stored Procedure to use as WHERE clauses, and if the parameter is null, I want the procedure to behave as though that condition doesn’t exist. example: if one of the input parameters is deviceType. if deviceType is null, query should simply be I know I can achieve this with if statements, but is