Conversion Fun

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by The Kid » Conversion Fun

26 posts, Page 1 of 3

1 2 3 »»»

Conversion Fun

Rate Topic

Display Mode

Topic Options

Author

Message

emanuel.unge

Posted Thursday, February 12, 2009 10:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:54 AM
Points: 26, Visits: 20

Comments posted to this topic are about the item Conversion Fun

Post #655898

SanjayAttray

Posted Thursday, February 12, 2009 1:40 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

SQL DBA.

Post #656081

JF1081

Posted Friday, February 13, 2009 7:44 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:13 AM
Points: 436, Visits: 322

Did I miss a month somewhere?

Post #656603

emanuel.unge

Posted Friday, February 13, 2009 7:57 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:54 AM
Points: 26, Visits: 20

i have no idea what happened here

Post #656631

Kit G

Posted Monday, February 16, 2009 9:02 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, March 29, 2013 8:18 PM
Points: 829, Visits: 4,098

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

Post #657829

The Dixie Flatline

Posted Thursday, February 19, 2009 8:49 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 10:41 AM
Points: 3,788, Visits: 5,538

Undocumented but useful: sp_MSGoBackInTime

__________________________________________________

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

Post #660454

Max-146500

Posted Monday, February 23, 2009 5:29 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 8:35 AM
Points: 271, Visits: 314

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

Max

Post #663146

INCREDIBLEmouse

Posted Wednesday, March 04, 2009 6:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 7, Visits: 51

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.

Post #668077

jcrawf02

Posted Wednesday, March 11, 2009 5:32 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:36 PM
Points: 2,549, Visits: 18,880

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
How to post performance problems
Tally Table:What it is and how it replaces a loop

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

Post #673110

Ronald H

Posted Wednesday, March 11, 2009 5:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, November 30, 2012 1:52 AM
Points: 1,116, Visits: 602

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 Hensbergen

Help 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

Post #673136

« Prev Topic | Next Topic »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions