Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » PARSE 1
Add to briefcase
31 posts, Page 1 of 4
1234»»»

PARSE 1 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
bitbucket-25253
Posted Saturday, December 15, 2012 1:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 5,099, Visits: 20,191
Comments posted to this topic are about the item PARSE 1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read
Post #1396907
Koen Verbeeck
Posted Sunday, December 16, 2012 2:02 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364, Visits: 6,462
Very very intesting question. Thanks Ron.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1397021
Thomas Abraham
Posted Sunday, December 16, 2012 3:38 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 1,146, Visits: 1,448
Been a long time since I was this happy to get a QOTD right. It wasn't that hard, but I wasn't sure of the deductive reasoning I was using. Thanks for the challenge Ron.

Please don't go. The drones need you. They look up to you.
Post #1397026
john.arnott
Posted Sunday, December 16, 2012 6:12 PM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:57 PM
Points: 1,491, Visits: 3,008
Another good QOD on a new feature of SQL 2012. Thanks, Ron.

BTW, I'm sure some of those who chose wrong answers will want to blame Microsoft for screwing up the BOL examples for TryParse(). Very strange to see that on what turns out to be an easy to understand function once you read the description.
Post #1397046
Lokesh Vij
Posted Sunday, December 16, 2012 9:58 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:58 AM
Points: 1,169, Visits: 1,244
Very Good Question Ron!
Keep pouring more of those SS2012 stuff..

~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter
Post #1397081
DugyC
Posted Monday, December 17, 2012 3:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:14 AM
Points: 1,160, Visits: 726
Thomas Abraham (12/16/2012)
Been a long time since I was this happy to get a QOTD right. It wasn't that hard, but I wasn't sure of the deductive reasoning I was using. Thanks for the challenge Ron.


+1 ... punching the air, almost like when I'd seen this weekends NFC East scores, I was.

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1397179
JoseACJr
Posted Monday, December 17, 2012 3:21 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:50 PM
Points: 438, Visits: 228
Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.
Post #1397180
Christian Buettner-167247
Posted Monday, December 17, 2012 3:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:36 AM
Points: 2,522, Visits: 3,616
JoseACJr (12/17/2012)
Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.

I was also quite surprised to see this answer and would have expected the SELECT to be atomic (either all or nothing). I dont have a 2012 handy so if someone could test this please?

Best Regards,
Chris Büttner
Post #1397186
rhythm.varshney
Posted Monday, December 17, 2012 3:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 21, 2013 2:14 AM
Points: 77, Visits: 184
Christian Buettner-167247 (12/17/2012)
JoseACJr (12/17/2012)
Hi,

Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.

I was also quite surprised to see this answer and would have expected the SELECT to be atomic (either all or nothing). I dont have a 2012 handy so if someone could test this please?



+2
Ron, can you please remove the confusion.
Post #1397189
DavidBridgeTechnology.com
Posted Monday, December 17, 2012 4:57 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 29, 2013 2:56 AM
Points: 58, Visits: 183
Select #2 Returns 2 rows ???

I don´t think so..

Error converting string value '2013DEC32 00:00:00' into data type datetime using culture ''.


Yep - I thought that too but also do not have 2012 handy to test.

I am also looking for confirmation.
I hate getting things wrong but if I do then I want to learn something!



David Bridge
David Bridge Technology Limited
www.davidbridgetechnology.com
Post #1397200
« Prev Topic | Next Topic »

Add to briefcase
31 posts, Page 1 of 4
1234»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.