Post reply

Today's Random Word!

  • December 8, 2011 at 11:11 am

    #1418842

    SQLRNNR (12/8/2011)

    L' Eomot Inversé (12/8/2011)

    Cadavre (12/8/2011)

    Boo, missed that 😛

    Here's my fixed version: -

    <code snipped>

    Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I was planning to wait for you (or anyone) to come up with the 24 -> 25 solution and then I could make a pedantic claim that one should use DATE not DATETIME to do date comparisons, but when it came to it I noticed that in fact I was still using datetime mostly. I can't even get the pedantry right when I'm trying to clown with it. Where's the face-palm icon?

    Fits well with your new Avatar.

    Maybe this one is better!

  • December 9, 2011 at 6:55 am

    #1419308

    Ninja's_RGR'us (12/8/2011)

    SQLRNNR (12/8/2011)

    L' Eomot Inversé (12/8/2011)

    Cadavre (12/8/2011)

    Boo, missed that 😛

    Here's my fixed version: -

    <code snipped>

    Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I was planning to wait for you (or anyone) to come up with the 24 -> 25 solution and then I could make a pedantic claim that one should use DATE not DATETIME to do date comparisons, but when it came to it I noticed that in fact I was still using datetime mostly. I can't even get the pedantry right when I'm trying to clown with it. Where's the face-palm icon?

    Fits well with your new Avatar.

    Maybe this one is better!

    It loses a lot without the vocal inflection, but here goes:

    Pie 😀

  • December 9, 2011 at 6:57 am

    #1419309

    Daniel Bowlin (12/9/2011)

    Ninja's_RGR'us (12/8/2011)

    SQLRNNR (12/8/2011)

    L' Eomot Inversé (12/8/2011)

    Cadavre (12/8/2011)

    Boo, missed that 😛

    Here's my fixed version: -

    <code snipped>

    Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I was planning to wait for you (or anyone) to come up with the 24 -> 25 solution and then I could make a pedantic claim that one should use DATE not DATETIME to do date comparisons, but when it came to it I noticed that in fact I was still using datetime mostly. I can't even get the pedantry right when I'm trying to clown with it. Where's the face-palm icon?

    Fits well with your new Avatar.

    Maybe this one is better!

    It loses a lot without the vocal inflection, but here goes:

    Pie 😀

    Don't you mean PANTS! :hehe::smooooth:

  • December 9, 2011 at 8:27 am

    #1419419

    WOTD - Recursive

  • December 9, 2011 at 8:31 am

    #1419424

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

  • December 9, 2011 at 8:33 am

    #1419428

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Recursive

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 8:39 am

    #1419437

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Sounds about right 😀

  • December 9, 2011 at 8:48 am

    #1419448

    Ninja's_RGR'us (12/9/2011)

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Sounds about right 😀

    As long as it is not infinite

  • December 9, 2011 at 8:50 am

    #1419451

    Revenant (12/9/2011)

    Ninja's_RGR'us (12/9/2011)

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Sounds about right 😀

    As long as it is not infinite

    Keep a mental note and come back to it in 1 year. We should have a pretty good idea. :-D;-)

  • December 9, 2011 at 9:04 am

    #1419475

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Iterative

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • December 9, 2011 at 9:05 am

    #1419476

    Revenant (12/9/2011)

    Ninja's_RGR'us (12/9/2011)

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Sounds about right 😀

    As long as it is not infinite

    I tried to make it infinite, but the person that posted after me (naming no names 😛 ) didn't quote me and reply with "Loop" to keep it going 😀

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 9, 2011 at 9:30 am

    #1419494

    Cadavre (12/9/2011)

    Revenant (12/9/2011)

    Ninja's_RGR'us (12/9/2011)

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Sounds about right 😀

    As long as it is not infinite

    I tried to make it infinite, but the person that posted after me (naming no names 😛 ) didn't quote me and reply with "Loop" to keep it going 😀

    Exactly. 😎

  • December 9, 2011 at 11:18 am

    #1419551

    17 days until Christmas?

    WOTD procrastination... haven't started thinking about Xmas presents yet, let alone shopping!

  • December 9, 2011 at 1:47 pm

    #1419619

    bcsims 90437 (12/9/2011)

    17 days until Christmas?

    WOTD procrastination... haven't started thinking about Xmas presents yet, let alone shopping!

    17 days posted on 9th? Only if you count both the 9th and the 25th, which isn't what most people do.

    Tom

  • December 10, 2011 at 9:41 am

    #1419724

    Revenant (12/9/2011)

    Ninja's_RGR'us (12/9/2011)

    Dev (12/9/2011)

    crookj (12/9/2011)

    WOTD - Recursive

    Loop

    Sounds about right 😀

    As long as it is not infinite

    Loop

    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

Viewing 15 posts - 5,566 through 5,580 (of 21,190 total)

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