Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-07 : 09:14:46
|
Jamin writes "Im makeing a scoreing table, in this table there are 18 rounds I want the sql to know what round is currently being played Im useing a trigger to do this. this is what I have so far.
CREATE TRIGGER "golfplaystrig" ON dbo.golfplays
AFTER UPDATE
AS
declare @value1 numeric, @value2 numeric, @value3 numeric,
@value4 numeric, @value5 numeric, @value6 numeric, @value7 numeric,
@value8 numeric, @value9 numeric, @value10 numeric, @value11 numeric,
@value12 numeric, @value13 numeric, @value14 numeric, @value15 numeric,
@value16 numeric, @value17 numeric, @value18 numeric, @roundid numeric
set @roundid = (Select (rounds) FROM inserted )
set @value1 = (Select (rd1) FROM inserted )
set @value2 = (Select (rd2) FROM inserted )
set @value3 = (Select (rd3) FROM inserted )
set @value4 = (Select (rd4) FROM inserted )
set @value5 = (Select (rd5) FROM inserted )
set @value6 = (Select (rd6) FROM inserted )
set @value7 = (Select (rd7) FROM inserted )
set @value8 = (Select (rd8) FROM inserted )
set @value9 = (Select (rd9) FROM inserted )
set @value10 = (Select (rd10) FROM inserted )
set @value11 = (Select (rd11) FROM inserted )
set @value12 = (Select (rd12) FROM inserted )
set @value13 = (Select (rd13) FROM inserted )
set @value14 = (Select (rd14) FROM inserted )
set @value15 = (Select (rd15) FROM inserted )
set @value16 = (Select (rd16) FROM inserted )
set @value17 = (Select (rd17) FROM inserted )
set @value18 = (Select (rd18) FROM inserted )
if @value1 >0 if @value2 <1
UPDATE golfplays SET ROUNDS = 1
if @value2 >0 if @value3 <1
UPDATE golfplays SET ROUNDS = 2
if @value3 >0 if @value4 <1
update golfplays set rounds = 3 WHERE keyid = 23
if @value4 >0 if @value5 <1
UPDATE golfplays SET ROUNDS = 4
if @value5 >0 if @value6 <1
UPDATE golfplays SET ROUNDS = 5
if @value6 >0 if @value7 <1
UPDATE golfplays SET ROUNDS = 6
if @value7 >0 if @value8 <1
UPDATE golfplays SET ROUNDS = 7
if @value8 >0 if @value9 <1
UPDATE golfplays SET ROUNDS = 8
if @value9 >0 if @value10 <1
UPDATE golfplays SET ROUNDS = 9
if @value10 >0 if @value11 <1
UPDATE golfplays SET ROUNDS = 10
if @value11 >0 if @value12 <1
UPDATE golfplays SET ROUNDS = 11
if @value12 >0 if @value13 <1
UPDATE golfplays SET ROUNDS = 12
if @value13 >0 if @value14 <1
UPDATE golfplays SET ROUNDS = 13
if @value14 >0 if @value15 <1
UPDATE golfplays SET ROUNDS = 14
if @value15 >0 if @value16 <1
UPDATE golfplays SET ROUNDS = 15
if @value16 >0 if @value17 <1
UPDATE golfplays SET ROUNDS = 16
if @value17 >0 if @value18 <1
UPDATE golfplays SET ROUNDS = 17
if @value18 >0
UPDATE golfplays SET ROUNDS = 18
The problem is, it does not change the current row it is on I dont want it to canges the full column because diffrent games are on diffrent rounds." |
|
|
|
|
|
|
|
Row ID