Conversion Fun

  • emanuel.unge

    SSC Enthusiast

    Points: 130

    Comments posted to this topic are about the item Conversion Fun

  • SanjayAttray

    SSChampion

    Points: 13157

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

    SQL DBA.

  • JF1081

    SSC Eights!

    Points: 982

    Did I miss a month somewhere?

  • emanuel.unge

    SSC Enthusiast

    Points: 130

    i have no idea what happened here

  • Kit G

    SSCrazy

    Points: 2748

    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

  • The Dixie Flatline

    SSC Guru

    Points: 53197

    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

  • Max-146500

    SSCarpal Tunnel

    Points: 4691

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

    Max

  • INCREDIBLEmouse

    SSC Eights!

    Points: 814

    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.

  • jcrawf02

    SSC-Insane

    Points: 24198

    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."

  • Ronald H

    SSCarpal Tunnel

    Points: 4022

    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

  • Brian LeBlanc-449582

    SSChasing Mays

    Points: 609

    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}

  • webrunner

    One Orange Chip

    Points: 29864

    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 says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • The Dixie Flatline

    SSC Guru

    Points: 53197

    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

  • webrunner

    One Orange Chip

    Points: 29864

    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 says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • The Dixie Flatline

    SSC Guru

    Points: 53197

    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 26 total)

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