how to call out procedure if the result has more than 1 row
Hi
I got the error when calling out the below, and i found out there were 2 employees with the same first and last name, in such cases, how do we call out both of them?
SET @v_emp_no = 0;
CALL employees.emp_info("georgi","facello", @v_emp_no);
SELECT @v_emp_no;
Error Code: 1172. Result consisted of more than one row
| 10001 | 1953-09-02 | Georgi | Facello | M | 1986-06-26 |
| 55649 | 1956-01-23 | Georgi | Facello | M | 1988-05-04 |
Hi Jaycus,
thanks for reaching out! Could you please provide a link to the lecture your question is referring to? This is the data visualization course and the building a dashboard in excel section, which features a data set from an FMCG data base - which doesn't include the rows you've provided as a screenshot.
Also if you did post your original question in another course (possibly SQL), please let us know, so that we can address the issue.
Best,
365 Eli
the function results in zero output please specify why
You need a space after "Sum of ". That should solve that error. **You also need to lock the 'Volumen' cell $B$33 (lioke that) so you can drag to the remaining cells and not get 0.**