Try putting the the result of your SELECT statement into a variable and then pass the variable to the stored procedure. SQL Server doesn't recognize the SELECT command as a parameter.
>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
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe
