Post reply

AVG function

  • June 20, 2011 at 8:10 pm

    #389792

    Comments posted to this topic are about the item AVG function

  • June 21, 2011 at 12:05 am

    #1341617

    Simple QotD today.

    -----------------
    Gobikannan

  • June 21, 2011 at 1:57 am

    #1341668

    Thank you Krishna

    M&M

  • June 21, 2011 at 3:54 am

    #1341705

    Nicee and easy if you read the question properly...

  • June 21, 2011 at 5:56 am

    #1341764

    Easy question if you don't talk yourself into thinking it's a trick question.

    http://brittcluff.blogspot.com/

  • June 21, 2011 at 6:14 am

    #1341777

    I made the same mistake I make all the time and forget about the datatypes.

    Good Question to make you think.

  • June 21, 2011 at 7:13 am

    #1341820

    Good question. Thanks.

  • June 21, 2011 at 7:19 am

    #1341825

    Makes it even more interesting if you add following:

    insert into @test-2 values ( NULL )

    Answer is still 6.

    Mike Byrd

  • June 21, 2011 at 7:25 am

    #1341830

    Mike Byrd (6/21/2011)

    Makes it even more interesting if you add following:

    insert into @test-2 values ( NULL )

    Answer is still 6.

    Because aggregate functions ignore NULLs, right?

    Good question today, thanks. I had it nailed on theory and then almost got it wrong by screwing up the math. 24 divided by 4 is NOT 8, duh. Tuesday morning brain, I guess.

    ron

    -----
    a haiku...

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

  • June 21, 2011 at 7:41 am

    #1341839

    Britt Cluff (6/21/2011)

    Easy question if you don't talk yourself into thinking it's a trick question.

    I have noticed that thier have not been any question that could be confused as a "Trick Question" in a LONG time. 😛

    Thank you Steve! 😀

  • June 21, 2011 at 7:42 am

    #1341840

    Nice easy clear to understand question. Thank you.

  • June 21, 2011 at 8:09 am

    #1341854

    Nice question. Simple and straight forward.

  • June 21, 2011 at 8:15 am

    #1341858

    Yay - thanks for the ?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 21, 2011 at 9:15 am

    #1341908

    Thanks for the question. Reminds us to remember those datatypes.

  • June 21, 2011 at 10:11 am

    #1341935

    Thanks. Good to see questions about things that come up all the time 🙂

    _____________________________________________________________________
    MCSA SQL Server 2012

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

You must be logged in to reply to this topic. Login to reply