Date Conversion Stored Procedure working on SQL 2008 but not on SQL 2005

En curso Publicado hace 7 años Pagado a la entrega
En curso Pagado a la entrega

Date Conversion Stored Procedure working on SQL 2008 but not on SQL 2005

We have a very short Stored Procedure written and working fine on SQL 2008.

Same stored Procedure is not working in SQL 2005.

We need a coder to be able to make it work in SQL 2005

The Stored Procedure is:

datediff(d,"VWTrucks"."BAFDate",convert(datetime,left("VWTrucks"."ReferenceNum",6)+'01')-1) as NoOfDaysDiff,

Servidor de Microsoft SQL

Nº del proyecto: #12003452

Sobre el proyecto

4 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

sumon355

Hello, As an expert in SQL, i am very much interested to do this work. I understand your requirements and i hope i can fix this problem. Looking forward to have a positive response from you. Thanks

$40 USD en 1 día
(41 comentarios)
5.6