Forum Replies Created

Viewing 3 posts - 856 through 859 (of 859 total)

  • RE: frustrating winzip and restore issue

    after trying to figure out what was going on i stayed up and watched the zip files be created at 3 am. and after a face palm realizing the...

    March 1, 2012 at 2:02 pm

    #1453877

  • RE: Make Rows As Columns

    in the sample data each role only has one userid associated with it. however the problem gets larger as more userid's are associated with each role as the min...

    February 23, 2012 at 1:03 pm

    #1451095

  • RE: Make Rows As Columns

    cengland0 (2/22/2012)

    Can't this be accomplished by a simple query like this:

    select

    productID,

    min(EventTime) as StartTime,

    max(EventTime) as EndTime,

    RoleName

    From [YourTableNameHere]

    Group by

    ProductID,

    RoleName

    That would work however there are userid's that repeat, so the min...

    February 23, 2012 at 12:40 pm

    #1451083

Viewing 3 posts - 856 through 859 (of 859 total)