Forum Replies Created

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

  • RE: CASE Statement

    Thanks again.
    Unfortunately, I am running this against an Informix database, and didn't realize the typical T-SQL doesn't work.
    However, for what I asked, the answers were perfect, and much...

    November 27, 2018 at 8:30 am

    #2014660

  • RE: CASE Statement

    Thank you guys!  I really really appreciate it.
    This one had my eyes crossing.
    I'm going to try this morning.
    Thanks!!

    November 21, 2018 at 6:57 am

    #2014208

  • RE: SQL Grouping

    So simple.  I was so close. 
    Thanks so much! I really appreciate it.

    December 28, 2017 at 6:58 am

    #1973696

  • RE: Report Builder - Where or Having Using Parameters

    Lowell - Wednesday, August 9, 2017 4:24 PM

    can you use a case statement to evaluate two different values based on your parameter? assuming the...

    August 10, 2017 at 6:56 am

    #1954793

  • RE: Rollup Incorrect - One Field

    While Erikur's point didn't end up applying, it did make me think of the way things were being calculated.
    I ended up making new variables for the count and yearly...

    February 6, 2017 at 3:20 pm

    #1926986

  • RE: Rollup Incorrect - One Field

    drew.allen - Monday, February 6, 2017 9:12 AM

    caldrumr1234 - Monday, February 6, 2017 8:28 AM

    February 6, 2017 at 2:37 pm

    #1926972

  • RE: Rollup Incorrect - One Field

    drew.allen - Monday, February 6, 2017 9:27 AM

    You really should be using a reporting tool (like SSRS) to do complicated reporting like...

    February 6, 2017 at 2:36 pm

    #1926970

  • RE: Rollup Incorrect - One Field

    Eirikur Eiriksson - Sunday, February 5, 2017 11:28 PM

    Quick question, what is the divisor ct in your TotAvg calculation?
    😎

    ((Jan2016t...

    February 6, 2017 at 8:28 am

    #1926881

  • RE: Rollup Incorrect - One Field

    colin.frame - Monday, February 6, 2017 1:36 AM

    @Eirikur - I think the ct comes from COUNT at the bottom of the query:

    February 6, 2017 at 8:27 am

    #1926878

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