|

Complete message thread: ( indicates your current position in the thread)

triger problem - mimi 7/13/00 10:56:13 AM


Subject:
From:
Date:
triger problem
mimi (mimi@hotmail.com)
7/13/00 10:56:13 AM



I am having problems getting this update statement work because of an upadate trigger i have on the table pls
help!!

this is the error message i get
Server: Msg 512, Level 16, State 1, Procedure TGR_ColloTIS_UPD, Line 13
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.
and this is the update querry

DECLARE @FiveBizDays datetime
DECLARE @Now datetime

SET @Now = GetDate()

EXEC dbo.basp_AddnWorkdays &#39;6/21/2000&#39;, -5, &#39;XX&#39;, @FiveBizDays OUTPUT

UPDATE mimi
SET columc = 4

WHERE columd IS NOT NULL AND columa IS NULL
AND columd < @FiveBizDays
AND (columb <> 4 OR columb IS NULL)

PRINT @FiveBizDays

this is the part of the trigger it is refering to
SET @strCL = (SELECT CR.LLI8digit FROM Request CR
INNER JOIN INSERTED INS ON CR.RequestId = INS.RequestId)

how do i change it?