you can do it so many ways but i give you simple ways
that is you change your SP
LIke:-
CREATE PROCEDURE hms.`Select_LastDate_Result`()
BEGIN
SELECT Current_Test_Date as 'Last_Date',Test_Result as 'Result'
FROM patient_progress_tracking_details
ORDER BY Current_Test_Date DESC limit 1;
--------------------------------
then you call this stored procedure as you calling above;
and other way you can used using out parameter sql
to search out parameter click following link:-
http://msdn.microsoft.com/en-us/library/ms187004(v=sql.105).aspx[
^]
http://sqlserverpedia.com/wiki/Stored_Procedures_-_Output_Parameters_%26_Return_Values[
^]
if problem exist than give your comment.....