Skip to content

Instantly share code, notes, and snippets.

@molbal

molbal/v_listaar.sql

Created May 23, 2019 07:23
Show Gist options
  • Save molbal/e5b0b3c9bf4945cf6ccfefd8cb1722c0 to your computer and use it in GitHub Desktop.
Save molbal/e5b0b3c9bf4945cf6ccfefd8cb1722c0 to your computer and use it in GitHub Desktop.
Download ZIP
Listaár számlálás
Raw
v_listaar.sql
BEGIN DECLARE v_listaar INT;
DECLARE v_euro FLOAT;
DECLARE v_ar_eur FLOAT;
SELECT listaar,
arEUR INTO v_listaar,
v_ar_eur
FROM products
WHERE ID = p_id;
SELECT Aktualis_arfolyam INTO v_euro
FROM arfolyam
WHERE ID = 1;
RETURN IFNULL(v_listaar, v_euro*v_ar_eur);
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment