ALTER PROCEDURE [test] 
@Leader_ID nvarchar(255)
	-- Add the parameters for the stored procedure here
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
SELECT a.Leader_ID , a.Employee_ID, e.EmployeeName,
(SELECT b.EmpProj_RWS (Select c.Subproj_Description from SubProj_Table c where c.Subproj_ID = d.SubprojID)
 FROM EmployeeProject_Table b
where a.Employee_ID = b.Employee_ID)
 AS Emp_RWS from LeaderEmployee_Table a, Employee_Table e, SubprojYear_Table d
where Leader_ID = @Leader_ID and e.Employee_ID = a.Employee_ID and d.SubprojYear_ID = b.SubprojYear_ID

END

SELECT a.Leader_ID , a.Employee_ID, e.EmployeeName,b.EmpProj_RWS,c.Subproj_Description
FROM LeaderEmployee_Table a
INNER JOIN  Employee_Table e ON e.Employee_ID = a.Employee_ID
LEFT JOIN EmployeeProject_Table b ON a.Employee_ID = b.Employee_ID
LEFT JOIN SubprojYear_Table d  ON d.SubprojYear_ID = b.SubprojYear_ID
LEFT JOIN SubProj_Table c ON  c.Subproj_ID = d.SubprojID
WHERE Leader_ID = @Leader_ID