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

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

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

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

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

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    February 23, 2012 at 12:40 pm

    #1451083

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