Forum Replies Created

Viewing 15 posts - 6,751 through 6,765 (of 9,399 total)

  • RE: NULL Aggregates

    Koen Verbeeck (1/7/2015)

    Xavon (1/7/2015)

    I wonder how MS is defining 'ignore'; because I would argue that if SUM ignored NULLs, I would not have to use half as many ISNULL(<column>, 0)...

    January 7, 2015 at 6:32 am

    #1768419

  • RE: Today's Random Word!

    batgirl (1/7/2015)

    Ed Wagner (1/7/2015)

    SQLRNNR (1/6/2015)

    Ed Wagner (1/6/2015)

    crookj (1/6/2015)

    SQLRNNR (1/6/2015)

    crookj (1/5/2015)

    Ed Wagner (1/5/2015)

    djj (1/5/2015)

    Ed Wagner (1/5/2015)

    Stuart Davies (1/5/2015)

    Ed Wagner (1/5/2015)

    SQLRNNR (1/2/2015)

    Sonic

    Boom

    Bust

    Museum

    Night

    History

    Buff

    BIFF

    Tree (Why don't you make like a tree and get out...

    January 7, 2015 at 6:28 am

    #1768417

  • RE: Today's Random Word!

    SQLRNNR (1/6/2015)

    Ed Wagner (1/6/2015)

    crookj (1/6/2015)

    SQLRNNR (1/6/2015)

    crookj (1/5/2015)

    Ed Wagner (1/5/2015)

    djj (1/5/2015)

    Ed Wagner (1/5/2015)

    Stuart Davies (1/5/2015)

    Ed Wagner (1/5/2015)

    SQLRNNR (1/2/2015)

    Sonic

    Boom

    Bust

    Museum

    Night

    History

    Buff

    BIFF

    Tree (Why don't you make like a tree and get out of here)

    Future

    Lightening

    1.21 Gigawatts

    January 7, 2015 at 5:58 am

    #1768404

  • RE: NULL Aggregates

    I also clicked COUNT right away, then paused and thought about GROUPING. I actually looked it up and saw that I didn't ignore NULLs. Guessing between the two...

    January 7, 2015 at 5:33 am

    #1768401

  • RE: Problems with partitioned views

    Really good question. For those of us who don't get to play with Enterprise Edition, partitioned views are the only option we have. Thanks very much.

    January 7, 2015 at 5:26 am

    #1768399

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/7/2015)

    Sean Lange (1/6/2015)

    I agree completely. Maybe a nice enhancement would be to conditionally add a button in a thread that you are subscribed to that would allow users...

    January 7, 2015 at 5:21 am

    #1768398

  • RE: Today's Random Word!

    TomThomson (1/6/2015)

    Ed Wagner (1/6/2015)

    djj (1/6/2015)

    crookj (1/6/2015)

    Ed Wagner (1/6/2015)

    TomThomson (1/5/2015)

    Ed Wagner (1/5/2015)

    djj (1/5/2015)

    Ed Wagner (1/5/2015)

    BWFC (1/5/2015)

    crookj (1/5/2015)

    Ed Wagner (1/5/2015)

    History

    Buff

    Polish

    Shine

    Moon

    Titan

    Cronus & Theia

    Zeus

    Orion

    Belt

    Black (Shodan)

    Nidan

    Sandan (I know a few)

    January 6, 2015 at 12:41 pm

    #1768205

  • RE: Convert to Datetime in Datediff

    Nice, Luis. I didn't consider using regular expression. I went down the road of splitting the parts of the date and then concatenating them and converting the result...

    January 6, 2015 at 12:23 pm

    #1768199

  • RE: Convert to Datetime in Datediff

    sharonsql2013 (1/6/2015)

    Sample :

    21 Dec 2014 00:16:15

    25 Oct 2014 00:16:18

    30 Dec 2014 00:16:53

    90000

    23 Oct 2013 00:16:27

    You probably already realize that it's always best to select an appropriate data type during design...

    January 6, 2015 at 11:51 am

    #1768190

  • RE: Today's Random Word!

    crookj (1/6/2015)

    SQLRNNR (1/6/2015)

    crookj (1/5/2015)

    Ed Wagner (1/5/2015)

    djj (1/5/2015)

    Ed Wagner (1/5/2015)

    Stuart Davies (1/5/2015)

    Ed Wagner (1/5/2015)

    SQLRNNR (1/2/2015)

    Sonic

    Boom

    Bust

    Museum

    Night

    History

    Buff

    BIFF

    Tree (Why don't you make like a tree and get out of here)

    Future

    January 6, 2015 at 11:29 am

    #1768182

  • RE: SA Account

    Let me cast another vote for not letting applications connect with sysadmin privs - it's just plain dangerous and you're asking for trouble. Ask yourself who's responsible for the...

    January 6, 2015 at 9:20 am

    #1768139

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/6/2015)

    Koen Verbeeck (1/6/2015)

    Ed Wagner (1/6/2015)

    Jeff Moden (1/6/2015)

    GilaMonster (1/5/2015)

    Jeff Moden (1/4/2015)

    I've taken to quoting the original post in many cases simply because too many people delete the original post even...

    January 6, 2015 at 9:13 am

    #1768135

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

    Phil Parkin (1/6/2015)

    Nice one Jeff 😎

    Agreed - very nice. Use math in a set and watch it fly.

    January 6, 2015 at 9:02 am

    #1768129

  • RE: Today's Random Word!

    djj (1/6/2015)

    crookj (1/6/2015)

    Ed Wagner (1/6/2015)

    TomThomson (1/5/2015)

    Ed Wagner (1/5/2015)

    djj (1/5/2015)

    Ed Wagner (1/5/2015)

    BWFC (1/5/2015)

    crookj (1/5/2015)

    Ed Wagner (1/5/2015)

    History

    Buff

    Polish

    Shine

    Moon

    Titan

    Cronus & Theia

    Zeus

    Orion

    Belt

    Black (Shodan)

    January 6, 2015 at 8:08 am

    #1768106

  • RE: Date Table

    BWFC (1/6/2015)

    Ed Wagner (1/6/2015)

    CELKO (1/6/2015)

    You just have to adjust your baking time.

    You mean I have to use kiloseconds for a kilogram cake :w00t:

    Silly me - I still use minutes...

    January 6, 2015 at 8:06 am

    #1768103

Viewing 15 posts - 6,751 through 6,765 (of 9,399 total)