Try scripting your current users. Then use your ADO connection. If you don't have the Enterprise Mgr then write the SQL to add the users.

I see what you mean, get rid of the duplicates and then I can use the SUM() for the aggregate.

Select o.JobID, SUM(i.Status)

From (

Select JobID, Status

From Jobs join Workphases on Jobs.JobID...

I have a small issue.  I have jobs with workphases and need a bitwise OR() aggregate function for the Status field.

Example:  Select JobID, OR(Status)

             ...