Post reply

Conversion Fun

  • February 12, 2009 at 10:00 am

    #200263

    Comments posted to this topic are about the item Conversion Fun

  • February 12, 2009 at 1:40 pm

    #943168

    This question is mentioned for March 11 and today is feb 12.

    SQL DBA.

  • February 13, 2009 at 7:44 am

    #943601

    Did I miss a month somewhere?

  • February 13, 2009 at 7:57 am

    #943626

    i have no idea what happened here

  • February 16, 2009 at 9:02 am

    #944630

    Steve must have gotten his hands on a time machine. Or a TARDIS. If so, I wanna know where he got it cause I want one! :w00t:

    -- Kit

  • February 19, 2009 at 8:49 am

    #946801

    Undocumented but useful: sp_MSGoBackInTime

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • February 23, 2009 at 5:29 pm

    #949088

    Shamefull, I blisfully ignored the first clause in the case statement that determined it was a character data type, oh bother.

    Max

  • March 4, 2009 at 6:03 am

    #953058

    Inexperienced person talking here, feel free to move to next topic. 🙂

    I got this one wrong as well. What threw me here is the fact that you assigned an integer value to the char. Now, to me, one would think that since you applied an int value to a char, it would just stop there and say something like "Are you stupid?". I assumed, that if it would magically convert the int value to string, and apply it, then it would truncate the string down to '1' automatically as well. If you had simply changed 10 to '10', the whole thing would have worked. It's because '10' would have worked that really made me fumble here.

  • March 11, 2009 at 5:32 am

    #957357

    SanjayAttray (2/12/2009)

    This question is mentioned for March 11 and today is feb 12.

    Now that's funny. Here it is March 11th, and it pops up again. sp_MSGoBackInTime really does work.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • March 11, 2009 at 5:59 am

    #957375

    I feel like being in Back to the Future... "The time-traveling is just too dangerous. Better that I devote myself to study the other great mystery of the universe: women!" Well, or SQL Server of course 🙂

    Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

  • March 11, 2009 at 6:26 am

    #957393

    I got it right and didn't even answer it... I guess I answered it right tomorrow. :hehe:

    Brian RL: Be serious about your work, but do not take yourself too seriously {Philip A. Fisher}

  • March 11, 2009 at 8:10 am

    #957502

    Brian LeBlanc (3/11/2009)

    I got it right and didn't even answer it... I guess I answered it right tomorrow. :hehe:

    Lucky you. I got the question wrong without even answering it. I took it as a sign that I should study my SQL better - and should do so in the present, not in the future. 🙂 (Actually, I think I answered it wrong back on Feb. 12 when it popped up early....)

    Cheers,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • March 11, 2009 at 8:32 am

    #957533

    Lucky you. I got the question wrong without even answering it.

    ME TOO !! 😛

    Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • March 11, 2009 at 8:37 am

    #957539

    Bob Hovious (3/11/2009)

    ...

    Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??

    Yes, but after an awkward incident wherein Sarah Connor ran by me pursued by a mean-looking cyborg, I thought it was best to roll back the HotFix ASAP.

    Cheers,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • March 11, 2009 at 8:43 am

    #957549

    Yeah that's what we had to do too. The cyborg got all bummed out about it and walked off muttering something about going into politics.

    😎

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

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