Try this:
CREATE PROCEDURE Sp_GetPersonVsFinanc
AS
BEGIN
SELECT p.Id,p.Name,p.Family,f.DebtValue,f.BestankarValue
from tbl_PersonInfo p join Financial f
on p.Id = f.FinancialPersonID
END
GO
You don't suppose to add
@source Table output
,
Select
command will take care of returning records.
--Amit