Forum Replies Created

Viewing 15 posts - 346 through 360 (of 417 total)

  • RE: Stupid Coding Tricks: The T-SQL Mandelbrot

    Never underestimate the capabilities of a clever but bored engineer. 🙂

    Don Simpson


    I'm not sure about Heisenberg.

    January 21, 2015 at 8:12 am

    #1771834

  • RE: Insert Statement with IF Statement

    INSERT(Test1)

    SELECT CASE WHEN @Test1='' THEN @Test1=NULL ELSE @Test1 END

    Is the " @test1=NULL" in the middle of the case statement correct? Shouldn't that just be "NULL"?

    Don Simpson


    I'm not sure about Heisenberg.

    January 20, 2015 at 2:09 pm

    #1771611

  • RE: Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

    What about converting a given column to a sparse column?

    Don Simpson


    I'm not sure about Heisenberg.

    January 16, 2015 at 9:04 am

    #1770787

  • RE: "Best Practices" Questions

    5 - NEVER EVER EVER use SSMS's 'Edit Top 200 Rows' feature. "Using this locks the table when the window is left open".

    I've all but proven this one untrue,...

    Don Simpson


    I'm not sure about Heisenberg.

    January 15, 2015 at 9:41 am

    #1770502

  • RE: IMPLICIT_TRANSACTIONS & BEGIN TRAN (second)

    Not sure what the purpose is for the "SET IMPLICIT_TRANSACTIONS OFF" at the end of the script.

    Don Simpson


    I'm not sure about Heisenberg.

    January 15, 2015 at 9:36 am

    #1770498

  • RE: Counting values

    If we ever work together we may never finish anything since we will just keep changing * to 1 and 1 to *. I am reminded of the Sneetches story...

    Don Simpson


    I'm not sure about Heisenberg.

    January 14, 2015 at 2:22 pm

    #1770252

  • RE: SQL Select stament

    Eirikur Eiriksson (1/10/2015)

    Jeff Moden (1/10/2015)

    Requires prior knowledge that the "T" is the exception. I realize that's exactly what the OP asked for but was that just because of the...

    Don Simpson


    I'm not sure about Heisenberg.

    January 14, 2015 at 1:09 pm

    #1770222

  • RE: Counting values

    MyDoggieJessie (1/14/2015)

    "COUNT()" returns total number of rows, irrespective of the contents...unless a specific column is specified that contains a NULL value, then those will be omitted

    That's not quite right. ...

    Don Simpson


    I'm not sure about Heisenberg.

    January 14, 2015 at 8:32 am

    #1770143

  • RE: Counting values

    Koen Verbeeck (1/14/2015)

    Nice but somewhat easy question (especially after the quite lengthy discussion of NULLs and aggregates last week). Not sure it is worth 2 points.

    +1, but I'll take the...

    Don Simpson


    I'm not sure about Heisenberg.

    January 14, 2015 at 8:21 am

    #1770137

  • RE: Can you count rows based on the group level instead of detail level

    You might have better luck doing the grouping is SQL.

    Don Simpson


    I'm not sure about Heisenberg.

    January 13, 2015 at 3:56 pm

    #1769971

  • RE: Running Totals

    What is the reporting or presentation tool that is replacing Excel? Something like Crystal or SSRS?

    Don Simpson


    I'm not sure about Heisenberg.

    January 13, 2015 at 10:44 am

    #1769887

  • RE: Can you count rows based on the group level instead of detail level

    Incidentally, I have a similar problem with CountDistinct. For a particular report, where there are 15 groups, this function:

    RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)

    skips 2 when the set is ordered alpha...

    Don Simpson


    I'm not sure about Heisenberg.

    January 13, 2015 at 10:27 am

    #1769879

  • RE: Can you count rows based on the group level instead of detail level

    gissah (1/13/2015)

    I am trying to count just the rows on group1 level without using CountDistinct in ssrs 2008 without counting the detail rows.

    CountRows("group1") or count(group1) all gives me the detail...

    Don Simpson


    I'm not sure about Heisenberg.

    January 13, 2015 at 10:15 am

    #1769871

  • RE: CHOOSE() a RAND() vowel not working???

    It's interesting that neither of these:

    substring('aeiouy', cast(rand() * 6 + 1 as int), 1)

    substring('aeiouy', cast(ceiling(rand() * 6) as int), 1)

    exhibit the same problem.

    Don Simpson


    I'm not sure about Heisenberg.

    January 9, 2015 at 9:00 am

    #1769119

  • RE: NULL Aggregates

    Koen Verbeeck (1/7/2015)

    DonlSimpson (1/7/2015)

    1 + 2 + 3 + NULL is NULL, absolutely. NULL is not replaceable by zero. Any set with a null value has a null...

    Don Simpson


    I'm not sure about Heisenberg.

    January 7, 2015 at 2:06 pm

    #1768602

Viewing 15 posts - 346 through 360 (of 417 total)