Em Andamento

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.

Habilidades: .NET

Ver mais: 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, stop project, help set, execute, stored procedure expert, stored procedure create sql

Acerca do Empregador:
( 51 comentários ) Cambridge, New Zealand

ID do Projeto: #170855

Premiar a:

Manishvsaraf

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 em 0 dias
(1 Comentário)
1.0

7 freelancers estão ofertando em média $51 para este trabalho

lavr

See private message.

$50 USD in 0 dias
(49 Comentários)
6.1
shmai

have a glance at PM. Regards,

$100 USD in 2 dias
(45 Comentários)
6.0
marr

Look at PM

$50 USD in 0 dias
(4 Comentários)
2.8
SweetyTharmaraj

I will do it

$30 USD em 1 dia
(0 Comentários)
0.0
oscguy

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 in 0 dias
(0 Comentários)
0.0
PALLISTA

Hi, i can have a look at this now.

$35 USD em 1 dia
(0 Comentários)
0.0