error, result consists of more than one record
Hi, why does it give error 1172 please? What is the problem with getting more than one record? thanks
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.