Knowledge




CREATE VIEW [dbo].[vw_ProjectResources]

AS

SELECT 

    R.EmployeeEmail,

    R.EmployeeDisplayName,

    R.EmployeeNWName,

    PR.ProjectID

FROM 

    [TT].[Resource] R

INNER JOIN 

    [TT].[ProjectResource] PR ON R.EmployeeNWName = PR.EmployeeNWName

WHERE 

    PR.ProjectID = @ProjectID;