-
triger problem
|
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 '6/21/2000', -5, 'XX', @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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|