Here you go

the problem was on your join

SELECT dimUser.EmpFullName1 [User Name]

, dimUser.MgrEmpFullName1 AS Manager

, dimUser.PrimaryJobName AS [Primary Job]

, dimUser.EmpNo AS [User Number]

, CONVERT(VARCHAR(10), fact.StartDtID, 101) [Start Date]

, CONVERT(VARCHAR(10), fact.EndDtID, 101) [Completion Date]

, dimUser.PrimaryOrgCode

, dimUser.SecondaryOrg1 AS [Secondary Org 1]

, dimUser.SecondaryOrg2 AS [Secondary Org 2]

, dimUser.PrimaryOrgName AS Org

, sd.DateDesc AS StartDate

, dd.DateDesc AS EndDate

, dimUser.EmpStat AS [Emp Status]

, CASE WHEN fact.completionStatusID = '-1' THEN 'Not Satisfied'

ELSE 'Satisfied'

END AS Status

FROM factAttempt AS fact

INNER JOIN dimActivity AS A ON A.ID = fact.ActivityID

INNER JOIN dimUser ON dimUser.ID = fact.UserID

INNER JOIN dimDate AS DD ON DD.DateID = fact.EndDtID

JOIN dimDate AS SD ON sD.DateID = fact.StartDtID

WHERE (dimUser.EmpStat = 'active')