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»»

Power of implicit conversion Expand / Collapse
Author
Message
Posted Monday, September 26, 2011 5:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:20 AM
Points: 1,767, Visits: 2,141
Excellent! Just the right amount of grey cell stimulation for an early Monday morning. Thanks.

Great example of taking two simple things you "know" (precedence and conversion) and synthesizing them into something greater than the two halves.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1180872
Posted Monday, September 26, 2011 6:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 11:04 AM
Points: 1,254, Visits: 13,552
good question!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1180903
Posted Monday, September 26, 2011 7:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
I had to look at it for a minute, but I noodled it out. Good question, thanks.
Post #1180957
Posted Monday, September 26, 2011 7:50 AM
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 24, 2014 7:30 AM
Points: 3,871, Visits: 3,621
Good question for a Monday.
Post #1180984
Posted Monday, September 26, 2011 8:42 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:33 PM
Points: 4,388, Visits: 3,399
That was an easy one... thanks!
Post #1181044
Posted Monday, September 26, 2011 9:31 AM


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: 2 days ago @ 10:34 AM
Points: 3,261, Visits: 1,955
Great Monday question!
Post #1181091
Posted Monday, September 26, 2011 9:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 1:04 PM
Points: 1,313, Visits: 1,055
Great question and explanation!

Reinforced two key concepts in one simple example. Thought it was a slam-dunk until the answer I wanted (23,5,6,6) wasn't available...doh! Nothing is a slam-dunk on a Monday morning.
Post #1181092
Posted Monday, September 26, 2011 9:42 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:09 PM
Points: 21,252, Visits: 14,960
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1181103
Posted Monday, September 26, 2011 5:01 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks - good question
Post #1181428
Posted Monday, September 26, 2011 10:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 1,032, Visits: 1,295
Great question.

Thanks
Post #1181466
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse