DELIMITER $$

USE bodb$$

DROP FUNCTION IF EXISTS Fn_XIRR$$

CREATE DEFINER=rxqueryuser@% FUNCTION Fn_XIRR(issue_date DATE) RETURNS DECIMAL(38,9)

DETERMINISTIC

BEGIN

DECLARE ytm_tmp DECIMAL (20,4);

DECLARE ytm DECIMAL (20,4);

DECLARE pv_tmp DECIMAL (20,4);

DECLARE pv DECIMAL (20,4);

DECLARE t DECIMAL (20,4);

SET ytm_tmp =...

Hi, why we are passing @issue_date in input param. we have already inserted the data's in table right. can you please help me out for the below sample, am trying...