Re: Error Code: 1172. Result consisted of more than one row INSIDE A FUNCTION

[Peter Brawley]

Your function does not appear restrict the result to one date. You need something like ...

create function `euro`(fec date ) returns decimal(11,2)
return ( select euro from data.iym where doer=@hoy and date=fec );

When building a query into an sproc or function, save yourself such hassle by always furst testing the query outside the routine.