• Now I Get this:

    Msg 245, Level 16, State 1, Line 2

    Conversion failed when converting the nvarchar value '11/13/1964' to data type int.

    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.DateDesc = fact.StartDtID

    WHERE (dimUser.EmpStat = 'active')