Search code examples
MIN&MAX value finding with condition...


sqlhana-sql-script

Read More
Add milliseconds to date in SQL, not seconds...


timestamphanamillisecondshana-sql-script

Read More
CE Join on columns with different names...


hanahana-sql-script

Read More
SQL "IS NOT NULL" in SAP HANA SQLScript...


hanaisnullhana-sql-script

Read More
How to convert an invalid number column to a number on HANA?...


hanahana-sql-script

Read More
Reset AUTO_INCREMENT field in SAP HANA...


hanahana-sql-script

Read More
REGEXPR_REPLACE string...


hanahana-sql-script

Read More
How to convert rows to columns and find top string...


sqlhana-sql-script

Read More
Creating a Column Store Table Type in HANA...


hanahana-sql-script

Read More
Does SQLScript for SAP HANA support the use of INSERT with CTEs (Common Table Expressions)?...


sql-insertcommon-table-expressionhanahana-sql-script

Read More
How to add tables in object privileges for a role...


hanahana-sql-scripthana-studio

Read More
Conditional update on HANA Studio (SQLScript) trigger...


hanasql-scriptshana-sql-scripthana-studio

Read More
Pass CLOB to system procedure SAP HANA...


hanasql-scriptshana-sql-script

Read More
Using REPLACE_REGEXPR in BW transformation throws syntax error...


hanahana-sql-scriptsap-bwamdp

Read More
How to get the last executed SQL statement in HANA?...


hanahana-sql-script

Read More
Looping over HANA table...


hanahana-sql-script

Read More
How to create a table variable for using in a JOIN?...


hanahana-sql-scripthana-studio

Read More
Why is it Not recommended feature: Using SELECT INTO in Scalar UDF...


hana-sql-script

Read More
Return max by two columns within dataset?...


maxhanahana-sql-script

Read More
JDBC: [337]: INTO clause not allowed for this SELECT statement...


hanahana-sql-script

Read More
Get keys of json formatted values in SQL (hana)...


sqlhanahana-sql-script

Read More
how to aggregate data based on condition...


sqlgroup-byhanapartition-byhana-sql-script

Read More
SAP HANA SQLScript in DBeaver...


hanadbeaverhana-sql-script

Read More
SQL Lag distinct - to the previous different value...


sqlcommon-table-expressionlagdistinct-valueshana-sql-script

Read More
SAP DBTech JDBC: [328]: invalid name of function or procedure: RECORD_COUNT. I don't understand ...


hanahana-sql-script

Read More
Error while selecting the calculation view through variables...


hanahana-sql-scripthana-studio

Read More
BETWEEN operator in filter expression...


hanabetweenhana-sql-script

Read More
Table totals to scalar variable in HANA...


hana-sql-scriptamdp

Read More
How to return CHAR30 in AMDP?...


abaphana-sql-scriptamdp

Read More
How to pass single-column table to AMDP method?...


abaphana-sql-scriptamdp

Read More
BackNext