Відео

we need this case function hana graphical view in column based

Hi Team, How to get these tables that has been used in the video session ?

Hi, this was helpful so if i want to convert this splitted string in different rows into single row then string_agg function to used right ?

Goodwin Gardens

Bailey Trail

Camylle Wall

Very Good Content, can we pass a dynamic table name and return data from the table name passed from the input

Ethelyn Key

Dalton Harbors

Stephanie Mills

Queen Forks

Kuvalis Alley

Could you please upload the complete SLT course.. or let us know the portal to enroll for

In summary, the process involves the separation of the data into two parts: a main part (Main) which contains most of the data organised in columns, and a delta part (Delta) which records recent changes in the data in the form of delta records organised in rows. Read queries are performed in both parts, while insert, update and delete operations are performed only in Delta. When Delta becomes full, the merge process is activated, where data from Main and Delta are merged and transferred to a new unit (Main2 and Delta2). During this process, continuity of data availability for read queries and write operations is ensured by using the old and new drives. Once the data merge and transfer is complete, the old drives are removed and the new drives are converted to the new main and delta configuration. This merge and transfer cycle is repeated periodically as needed to maintain optimal performance and efficient data management in the SAP HANA database.

Thank you, it is very intersting. But I have a problem. I can't see the raw data, i get following error: Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '3506A717C4FE6449ABC5400BF1080F3C' It means, that I need select-privileges to execute the view ("_SYS_BIC"."T4H_PACK/SALES_REPORT") in den schema _SYS_BIC. But I can't give me this privileges and the use SYSTEM can't do it. Only the SYS can do it ... but the SYS is not active.

How to implement multi value input parameter?

Very Nice explanation

NICE TUTORIAL

GREAT TUTORIAL!

Hi. as result came in table then is it possible to use this table directing to join other table?

in real time who creates slt ? developer or admin?

Hi Sir, Please give the notepad with sql coding to practice

interesting your explanation

Videos are very simple and detailed. Could you please upload a video to download latest version of SAP SQL software.

Thank you, great video! :)

Hi sir, Thank you a ton for these wonderful sessions. These videos have the capability to uphold many jobless lives and make them stand strong on their feet. This comment is to actually let you know that there is a bug in the code at line number 24 of your Video 56 (Transaction Application) where your have written the logic for calculating the BALANCE. In fact everything is right but the calculation needs to be carried w.r.t each account we are inputting because the withdraw needs to happen when the BALANCE of that respective account is greater than the amount being withdrawn from that corresponding account. But since no WHERE clause is mentioned w.r.t ACCOUNT, the balance is calculated for all the accounts present in the table. Coincidentally due to certain conditions being met, the code gave the expected outputs and it made you feel that the logic is correct. Kindly re-check and rectify it if possible. Once again bowing my head with deep respect for such immense effort you did put to share your knowledge and making our lives easy.

ansi sql standard recommends the use of an explicit connection

Can you share contact info like mail or mobile no, inline query

hi Team , Are u still teaching HANA SQL scripting

SORRY SIR YOUE ALL CONTAINE IS INTRASTING I AM JOINE YOUR COURCE BUT THIS FACTOREAL EXAMPLE I NOT UNDERSTAND CAN YOU PLSE EXPLAIN AGAINE ???...

Can we call this stored procedure from ecc ? If yes how

RESULT := :IP * 80 / 100

This is no longer available unless you have a business email address. I can't find any workaround. That's super disappointing.

it is working on abap also ?

HI SIR ,WHERE IS PK_SALES TABLE??

didn't get the reason for making auto-commit off. request you to please explain

Is it possible Recursive function in SAP HANA Script? If not, what is the alternative way to do it?

what is the difference between:= and = as you have used both for assigning values to variables ? Also can you pls let me know why we use : colon before IN parameter name, can't we directly use parameter name ?

How to start learning SQL in sap pls advise..

Thanks for sharing this. Third option could be use of ifnull function

Very nice explaination and it is very helpful video for better understanding

Good video, no one is explaining on input dynamic parameters Every one just entering hard coded values 😀😀. 👍👍🙏

Please upload more videos. Your videos are really helpful

You Explained very well

CREATE or REPLACE

do you use eclipse for create stored procedure ?

Sir need full training videos, please help me

Please let us know how to get the access of complete SLT course. It's incomplete here, do we need to purchase it.

thanks' .

time4hana i need your email address or number i want to learn sap hana sql script