Hi, why does it give error 1172 please? What is the problem with getting more than one record? thanks

Hi Kfir! Thanks for reaching out. This error 1172 means that there are multiple individuals that share this first and last names while the procedure has been created for individuals that are unique in terms of first-and-last name combination. In other words, the query works only for unique combinations of first and last name. In case there is more than 1 person bearing the same first and last name (as is the case with Georgi Facello), the query should provide error code 1172: Result consisted of more than one row; which is something a stored procedure can't handle. You can simply remove the output parameter and it will work, but the topic is about output parameter, so better use an unique combination. Hope this helps. Best, Tsvetelin

Follow this topic

kfir ben galil

Last answered:

03 Oct 2022

Posted on:

03 Oct 2022

error, result consists of more than one record

in SQL / Variables

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

03 Oct 2022

error, result consists of more than one record

Submit an answer

related questions