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

In Progress Posted 7 years ago Paid on delivery
In Progress Paid on delivery

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,

Microsoft SQL Server

Project ID: #12003452

About the project

4 proposals Remote project Active 7 years ago

Awarded to:

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 in 1 day
(41 Reviews)
5.6