Member since ‎02-01-2019

User Statistics

  • 5 Posts
  • 0 Solutions
  • 13 Kudos given
  • 62 Kudos received

User Activity

Introduction In this post, I'm going to show you how to use the SQL API for the SAP HANA Deployment Infrastructure (HDI). First of all we will setup our environment. We will create a new tenant and enable the diserver on this tenant. If you have alr...
Introduction In this post, I will show you with an example why you should avoid the use of cursors, if there are other ways to fulfill your requirements. What is a cursor Cursors are used to fetch single rows from the result set returned by a query a...
Introduction Currently there is no built-in pivot/unpivot function in HANA. In this blog you will find a workaround how to implement this in SQLScript. Pivot/Unpivot Pivoting is the transformation from the rows into the columns. Unpivoting is the ...