Viewing 3 posts - 1 through 3 (of 3 total)
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.
June 22, 2004 at 9:00 am
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)
Select JobID, Status
From Jobs join Workphases on Jobs.JobID...
June 22, 2004 at 6:31 am
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)
June 21, 2004 at 9:11 am