Færdiggjort

SQL Trigger

HI

I have an Update SQL Trigger. This works fine as long as there is only 1 row affected in the base table.

I need the trigger to work even when update is on multirows.

The trigger is? caluclating a value? for one of the fields in the updated record based.

?

A solution where by the "Calculation" is done via Stored Procedure or Constraint is also acceptable.

I will give the current Trigger code to those who are serious about giving me a solution.

Attaching to the bid is the Trigger code as it is now..

When Attempting the following in SQL

UPDATE? CUSTOMERITEMS? SET PERCENTAGE =300

The following is the error I get

Msg 512, Level 16, State 1, Procedure updateFixed, Line 24

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

The statement has been terminated.

Regards

Meir

## Deliverables

* * *This broadcast message was sent to all bidders on Tuesday Apr 6, 2010 9:34:13 AM:

I want to pick a coder within the next 3 hrs so anyone who has recieved the Trigger code and error message please respond with you final price quote.

Evner: Ingeniørarbejde, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning

Se mere: sql price, sql statement stored, sql final, update code sql, sql management base, php sql update, update sql code, sql trigger update, SQL stored, code attaching sql, 2010 procedure, project based sql, trigger stored procedure php, trigger procedure php, sql update, sql base, sql sql, sql update fields, level sql, calculation apr

Om arbejdsgiveren:
( 26 bedømmelser ) k, Israel

Projekt ID: #3322185

Tildelt til:

webdevelopevw

See private message.

$7 USD på 1 dag
(6 bedømmelser)
1.9

12 freelancere byder i gennemsnit $18 på dette job

templecityt

See private message.

$21.25 USD på 1 dag
(21 bedømmelser)
5.5
sathyanus

See private message.

$17 USD på 1 dag
(81 bedømmelser)
5.2
f1mei0

See private message.

$21.25 USD på 1 dag
(52 bedømmelser)
5.1
wrarvw

See private message.

$21.25 USD på 1 dag
(22 bedømmelser)
4.0
dotkam

See private message.

$19.55 USD på 1 dag
(14 bedømmelser)
2.8
enghany

See private message.

$19.55 USD på 1 dag
(1 bedømmelse)
1.3
mohdshahidvw

See private message.

$15.3 USD på 1 dag
(2 bedømmelser)
1.1
shrireadytocode

See private message.

$15.3 USD på 1 dag
(0 bedømmelser)
0.4
mahimams

See private message.

$21.25 USD på 1 dag
(1 bedømmelse)
0.0
gurusamyk

See private message.

$12.75 USD på 1 dag
(0 bedømmelser)
0.0
gbid

See private message.

$19.55 USD på 1 dag
(1 bedømmelse)
0.0