---
parser: v2
author_name: Rich Heilman
author_profile: https://github.com/rich-heilman
primary_tag: products>sap-hana
tags: [  tutorial>intermediate, topic>sql, products>sap-hana, products>sap-hana-cloud, products>sap-business-application-studio]   
time: 15
slug: hana-cloud-sqlscript-parallel
canonical_url: https://developers.sap.com/tutorials/hana-cloud-sqlscript-parallel
---

# Parallel Processing and Parameters 
<!-- description --> Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.

## Prerequisites  
- This tutorial is designed for SAP HANA Cloud.
- **Tutorials:** [Creating Stored Procedures](hana-cloud-sqlscript-stored-proc)

## You will learn  
- How to take full advantage of parallel processing in SAP HANA by using table variables

## Intro
In this exercise, we will modify the code of procedure `get_po_header_data`  so that it takes full advantage of the parallel processing within HANA by using table variables.

---

### Edit previous procedure


1. Return to your procedure called `get_po_header_data`.

    ![Existing Procedure](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/1_1.png)

2. Define two tabular output parameters which will be used to explicitly pass the results of the SELECT statements to the caller.

    ![Define output](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/1_2.png)

3. Next, assign SELECT statements to the output parameters as shown here.

    ![assign select](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/1_3.png)

4. The completed code should be similar to this.

   ```SQLCRIPT
   PROCEDURE "get_po_header_data"(
            OUT EX_PO_CREATE_CNT TABLE(
              CREATE_CNT INTEGER,
              "CREATEDBY" NVARCHAR(255)),
           OUT EX_PO_CHANGE_CNT TABLE(
              CHANGE_CNT INTEGER,
              "MODIFIEDBY" NVARCHAR(255))  )
      LANGUAGE SQLSCRIPT
      SQL SECURITY INVOKER
      --DEFAULT SCHEMA <default_schema_name>
      READS SQL DATA AS
   BEGIN

   ex_po_create_cnt =  SELECT COUNT(*) AS CREATE_CNT, "CREATEDBY"
        FROM "OPENSAP_PURCHASEORDER_HEADERS" WHERE ID IN (
                        SELECT "POHEADER_ID"
                             FROM "OPENSAP_PURCHASEORDER_ITEMS"
             WHERE "PRODUCT_PRODUCTID" IS NOT NULL)
               GROUP BY  "CREATEDBY";

   ex_po_change_cnt = SELECT COUNT(*) AS CHANGE_CNT, "MODIFIEDBY"
        FROM "OPENSAP_PURCHASEORDER_HEADERS"  WHERE ID IN (
                        SELECT "POHEADER_ID"
                             FROM "OPENSAP_PURCHASEORDER_ITEMS"
             WHERE "PRODUCT_PRODUCTID" IS NOT NULL)
                GROUP BY  "MODIFIEDBY";

   END
   ```


### Save, deploy, run and check results


1. Save the procedure.

    ![Save Procedure](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/2_1.png)

2. Perform a **Deploy**

    ![Deploy](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/2_2.png)

3. Use what you have learned and return to the Database Explorer page and run the procedure again.

    ![DBX](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/2_3.png)

4. The CALL statement will be inserted into a new "SQL" tab. Click the **Run** button

    ![Run](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/2_4.png)

5. Check the execution time again, you may notice that it is a bit faster this time depending on your system. The reason is that these SQL statements are now executed in parallel.

    ![Check execution time](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-parallel/2_5.png)