Problem with Split Function in SQL... RSS

• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 07:39 AM|LINK

  yrb.yogi

  I am showing you a simple demo of how to use split data...

  you just need to cast your splitdata to datetime as follow..and use that column for join..

  I tried it but not able to solve same error...

• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 07:42 AM|LINK

  jeeten09

  I tried it but not able to solve same error...

  You must need to cast your varchar column to datetime. Check weather your varchar column contain valid datetime value..like MM/DD/YYYY etc.

  for better, you must check in where cluase IsDate(yourColumn)=1 to get proper datetime..

  Yogesh Bhadauriya
  .Net All About
  
• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 07:44 AM|LINK

  yrb.yogi

  You must need to cast your varchar column to datetime. Check weather your varchar column contain valid datetime value..like MM/DD/YYYY etc.

  for better, you must check in where cluase IsDate(yourColumn)=1 to get proper datetime..

  Im using Date Format as dd-MMM-yyyy & You can see it in the data as i gave u before...

• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 07:50 AM|LINK

  jeeten09

  Im using Date Format as dd-MMM-yyyy & You can see it in the data as i gave u before...

  That is the reason you got error..

  Set Dateformat to dd-mm-yyyy

  like below..

  SET DATEFORMAT DMY;
  
  --rest of query will come here
  
  SET DATEFORMAT MDY;

  Yogesh Bhadauriya
  .Net All About
  
• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 07:55 AM|LINK

  yrb.yogi

  Set Dateformat to dd-mm-yyyy

  like below..

  SET DATEFORMAT DMY;
  
  --rest of query will come here
  
  SET DATEFORMAT MDY;

  Can i set dateformat in Query only ???

  How ???

  Or anyother easy way to do it ???

• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 08:06 AM|LINK

  jeeten09

  Can i set dateformat in Query only ???

  How ???

  Or anyother easy way to do it ???

  You can set dateformat in query too.

  i think this is easy way..

  Yogesh Bhadauriya
  .Net All About
  
• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 08:16 AM|LINK

  yrb.yogi

  You can set dateformat in query too.

  i think this is easy way..

  huh ?

  still same here...

• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 08:21 AM|LINK

  jeeten09

  huh ?

  still same here...

  Now you must need to show your entire query here...and where & which column you are getting error

  Yogesh Bhadauriya
  .Net All About
  
• • Reply
  

  jeeten09

  Member

  122 Points

  150 Posts

  Re: Problem with Split Function in SQL...

  Mar 02, 2012 08:42 AM|LINK

  yrb.yogi

  Now you must need to show your entire query here...and where & which column you are getting error

  msg me ur email id

• • Reply
  

  Chen Yu - MS...

  All-Star

  21569 Points

  2493 Posts

  Microsoft

  Re: Problem with Split Function in SQL...

  Mar 07, 2012 06:34 AM|LINK

  Hi jeeten09,

  Have you solved your problem? If not, please post your whole query, it will provide us more information about your issue. Thanks for your understanding.

  Thanks.

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store