Find Jobs
Hire Freelancers

Help with Stored Procedure for MSSQL

$30-100 USD

Selesai
Dibuat lebih dari 16 tahun yang lalu

$30-100 USD

Dibayar ketika dikirim
Database Environment is MSSQL 2000 and operating system is Windows Server 2003 The task is to create a stored procedure which works on a single table and is scheduled to execute automatically every 1 hour (preferably at 15 minute intervals but I cannot see how this can be done in the SQL Server Agent). The table is called ClassifiedAds, and the procedure has to perform the following checks: [login to view URL] to see if expiry date < current system date. if it is then set status to 0 2. Check to see if Price = stop price and if it is then set IsTrue to 0 3, perform update which says to reduce current price (price=[price-reduceby) where status = 1 and IsTrue = 1 This is fairly straight forward for an expert and I just do not have the luxury of time to sit down and work how to do write the procedure. It is required urgently and this project will be awarded to someone who can deliver completed within 1-2 days.
ID Proyek: 170855

Tentang proyek

7 proposal
Proyek remot
Aktif 17 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
I am a S/W eng. working in Database Environment MSSQL 2000 and operating system is Windows Server 2003 I already done same thing,in Inventory system for report generation. For that purpose I used SQL Server Agent.
$30 USD dalam 0 hari
5,0 (1 ulasan)
1,0
1,0
7 freelancer menawar dengan rata-rata $51 USD untuk pekerjaan ini
Avatar Pengguna
See private message.
$50 USD dalam 0 hari
5,0 (49 ulasan)
6,1
6,1
Avatar Pengguna
have a glance at PM. Regards,
$100 USD dalam 2 hari
4,7 (45 ulasan)
6,0
6,0
Avatar Pengguna
Look at PM
$50 USD dalam 0 hari
4,7 (4 ulasan)
2,8
2,8
Avatar Pengguna
I will do it
$30 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, please check my reviews there and won project with complex MSSQL Stored Procedure task on PMB to make sure i can help you to get the task done quickly around 4 hours MAX Regards
$60 USD dalam 0 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, i can have a look at this now.
$35 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera NEW ZEALAND
Cambridge, New Zealand
5,0
51
Memverifikasi Metode pembayaran
Anggota sejak Mei 6, 2004

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.