Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Conversion Fun Expand / Collapse
Author
Message
Posted Thursday, February 12, 2009 10:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Thursday, February 12, 2009 1:40 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
This question is mentioned for March 11 and today is feb 12.

SQL DBA.
Post #656081
Posted Friday, February 13, 2009 7:44 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 7, 2010 8:13 AM
Points: 436, Visits: 322
Did I miss a month somewhere?
Post #656603
Posted Friday, February 13, 2009 7:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, February 16, 2009 9:02 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 5, 2013 2:13 PM
Points: 556, Visits: 4,099
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!

-- Kit
Post #657829
Posted Thursday, February 19, 2009 8:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 2,787, Visits: 6,098
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
Posted Monday, February 23, 2009 5:29 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:07 AM
Points: 247, Visits: 356
Shamefull, I blisfully ignored the first clause in the case statement that determined it was a character data type, oh bother.

Max
Post #663146
Posted Wednesday, March 4, 2009 6:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 26, 2014 4:01 AM
Points: 26, Visits: 164
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
Posted Wednesday, March 11, 2009 5:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:08 PM
Points: 1,328, Visits: 19,288
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
Posted Wednesday, March 11, 2009 5:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 9, 2013 5:08 AM
Points: 1,123, Visits: 603
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse