Hi!
Try to use variable:
IF UPDATE(myfield)
BEGIN
SELECT @MyVar = (SELECT mySecondField FROM INSERTED)
EXECUTE myStoredProc 1, @MyVar
END
>Hi,
>
>Anyone has made somthing like this, on a INSERT trigger:
>
>IF UPDATE(myfield)
>BEGIN
> EXECUTE myStoredProc 1, (SELECT mySecondField FROM INSERTED)
>END
>
>
>SQL Server return error at the "(".
>
>Any ideas?
>
>Thanks,
>
>Ricardo
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.