Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Installing MSDE Only

    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.

  • RE: Bitwise Aggregreates

    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...

  • RE: Using Bits to Store Data

    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)


Viewing 3 posts - 1 through 3 (of 3 total)