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

sedang Berlangsung Dipasang 7 tahun yang lalu Dibayar saat pengiriman

$30-250 USD

Dibayar saat pengiriman

sedang Berlangsung Dibayar saat pengiriman

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

ID Proyek: #12003452

Tentang proyek

4 proposal Proyek online Aktif 7 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Atur anggaran dan kerangka waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Ini gratis untuk mendaftar dan menawar pada pekerjaan

Diberikan kepada:

Gambar Profil sumon355
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 dalam 1 hari
(41 Ulasan)
5.6
Buat sebuah proyek seperti ini