Forum Replies Created

Viewing 15 posts - 1 through 15 (of 192 total)

  • RE: SSRS Chart filter working backwards

    sgmunson - Wednesday, February 13, 2019 1:11 PM

    XI is probably far improved over version 9.   I've been pulling my hair out messing...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: SSRS Chart filter working backwards

    sgmunson - Wednesday, February 13, 2019 1:05 PM

    Which version are you using?

    Crystal XI.

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: SSRS Chart filter working backwards

    sgmunson - Wednesday, February 13, 2019 12:57 PM

    I wouldn't wish that on your worst enemy.   Try changing a data source on...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: SSRS Chart filter working backwards

    sgmunson - Wednesday, February 13, 2019 12:42 PM

    Are you sure that the filters are coded for = as opposed to <> ?

    Absolutely sure. Here's...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Performance: TRUNCATE vs. DROP/CREATE

    GilaMonster - Wednesday, June 21, 2017 11:03 AM

    ronmoses - Wednesday, June 21, 2017 9:04 AM

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Performance: TRUNCATE vs. DROP/CREATE

    GilaMonster - Wednesday, June 21, 2017 7:49 AM

    Did you check for waits, see if the query is waiting for something and if...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Performance: TRUNCATE vs. DROP/CREATE

    Luis Cazares - Wednesday, June 21, 2017 7:07 AM

    Did you check for any blocking happening while testing?

    It's a test environment, and I'm...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Performance: TRUNCATE vs. DROP/CREATE

    It's probably not worth stating, but just in case... I did run this part of the script in isolation and confirmed that the time difference is not taking place here.

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Seems like a job for a window function, but...

    Okay, I have a lot of learning to do today. 🙂 Thank you, Luis!

    ron

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Seems like a job for a window function, but...

    Now that I'm starting to understand it, I can see that it relies on the quirk of my sample data that the timestamps are sequential by one minute. (That was...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Seems like a job for a window function, but...

    Thank you, Luis! I will be diving into that article and getting my head around it if it kills me! (It might.) 😀

    ron

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: ISNULL vs COALESCE

    Hugo Kornelis (4/17/2015)


    The question is okay, but the explanation is absolutely incorrect.

    Thank you for stating it far more eloquently and intelligently than I did. 🙂

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: ISNULL vs COALESCE

    I'm not sure it's accurate to say "all need to be of the same data type." I believe all need to be able to be implicitly converted to the data...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Using APPLY to make your queries DRYer

    INCREDIBLEmouse (4/2/2015)


    Why not, cross apply (something) as SomethingDescriptiveButNotThisLong

    I also prefer at least semi-descriptive table aliases, just to help me keep track of where different values are coming from. So for...

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • RE: Obedience Training For Databases: Cascading Constraints

    (deleted by author)

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

Viewing 15 posts - 1 through 15 (of 192 total)