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 «««12345

Conditional Order By Expand / Collapse
Author
Message
Posted Monday, November 22, 2010 5:40 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 1,805, Visits: 6,580
Excellent question - which I got right due to having been buitten by exactly this problem in the past, and it took ages to track down the cause
Post #1024253
Posted Wednesday, November 24, 2010 11:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:49 PM
Points: 17,967, Visits: 15,979
Thanks for the question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1026072
Posted Thursday, November 25, 2010 5:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:05 PM
Points: 157, Visits: 292
Thanks for posting this.

I am new to SQL server programming. Though both question and answer was clear i would like to know the reason or why SQL server is performing CONVERT_IMPLICIT(datetime,[Union1007],0).(ie why String1, String2 is converted to datetime).

Thanks
Post #1026440
Posted Thursday, November 25, 2010 5:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:38 PM
Points: 1,805, Visits: 5,870
Gopinath Srirangan (11/25/2010)
Thanks for posting this.

I am new to SQL server programming. Though both question and answer was clear i would like to know the reason or why SQL server is performing CONVERT_IMPLICIT(datetime,[Union1007],0).(ie why String1, String2 is converted to datetime).

Thanks


Please see this post for an explanation : http://www.sqlservercentral.com/Forums/FindPost1021495.aspx


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1026442
    « Prev Topic | Next Topic »

    Add to briefcase «««12345

    Permissions Expand / Collapse