(Msg 2714, Level 16, State 3, Procedure report_doctors_and_patients, Line 1 [Batch Start Line 7] There is already an object named 'report_doctors_and_patients' in the database. y la funcion esta correcta ) CREATE FUNCTION report_doctors_and_patients() RETURNS @dotp_table TABLE( doctor_name varchar(25), doctor_lastname varchar(25), patient_name varchar(25), patient_lastname varchar(25) ) AS

BEGIN INSERT INTO @dotp_table SELECT doc.doctor_name, doc.doctor_lastname, pat.patient_name, pat.patient_lastname FROM doctors_assigned_to_patients AS datp INNER JOIN doctors AS doc ON datp.staff_id = doc.staff_id INNER JOIN patients AS pat ON datp.patient_id = pat.patient_id; RETURN ;
END;