Help with Stored Procedure for MSSQL

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:

[url removed, login to view] 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.

Compétences : .NET

en voir plus : sql create table price, mssql stored procedure perform update, sql scheduled stored procedure execution, update status expiry date mssql, create mssql, procedure mssql, sql stored procedure check expiry date, where can i work at 15, stored, server help, mssql, help windows, expert operating, c# MSSQL, mssql stored, reduce sql, set hour, scheduled, sql reduce, task help

Concernant l'employeur :
( 51 commentaires ) Cambridge, New Zealand

Nº du projet : #170855

Décerné à:


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.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(1 Évaluation)

7 freelance font une offre moyenne de $51 pour ce travail


See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(49 Commentaires)

have a glance at PM. Regards,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(45 Commentaires)

Look at PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(4 Commentaires)

I will do it

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)

Hi, i can have a look at this now.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)