title: how to assign a variable in procedure in SAP HANA
body: <p>here i tried to give discount based on quantity ordered by using procedure. but i dont know how assign a value of column to the variable in procedure.</p>
  
  <p>here my code:</p>
  
  <pre><code>create column table "KABIL_PRACTICE"."SALES_IF_ELSE"
  (
  "SALES_ID" integer,
  "PRODUCT_ID" integer,
  "QTY" integer,
  "DISCOUNT" integer,
  "SALES_AMOUNT" Double
  );
  
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (1,101,15,1500);
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (2,102,25,2500);
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (3,103,35,3500);
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (4,104,40,4000);
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (5,105,27,2700);
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (6,106,32,3200);
  insert into "KABIL_PRACTICE"."SALES_IF_ELSE" ("SALES_ID","PRODUCT_ID","QTY","SALES_AMOUNT") values (7,107,19,1900);
  
  create procedure "KABIL_PRACTICE"."IF_ELSE_DISC"
  language sqlscript
  as begin
  declare QTY integer ;
  select "QTY" from "KABIL_PRACTICE"."SALES_IF_ELSE" := QTY;
  if ( QTY &gt; 25)
  then
  update "KABIL_PRACTICE"."SALES_IF_ELSE" set "DISCOUNT" = 5;
  else if
  update "KABIL_PRACTICE"."SALES_IF_ELSE" set "DISCOUNT" = 1;
  end if;
  end if;
  end;
  </code></pre>
  
  <p>anyone help me....</p>