My second post showed how I got around the problem - it offends my aesthetic sensibilities but that's TSQL for you.

something appears to have gone adrift when I cut and pasted the code the line with trigger nestlevel should read:

if trigger_nestlevel() < 2 AND @EventTemplateID = @TemplateID AND @SRno...

something appears to have gone adrift when I cut and pasted the code the line with trigger nestlevel should read:

if trigger_nestlevel() ''

Yes - but I am using the trigger with a third party applications database so I am not sure that I can turn off recursive triggers as that is a...

This table should only be updated one row at a time. Since I'm making my way with SQL server I'm trying to keep things simple, but I agree that I...

Got it - using some of the hints earlier in the thread:

[font="Courier New"]ALTER PROCEDURE SR_numinput

@SR_number VARCHAR(20),

@customer VARCHAR(50) OUTPUT,

@project VARCHAR(20) OUTPUT

AS

BEGIN

declare @query...

I'm running into the same problems with OPENQUERY. Not being able to provide it with a string argument containing a dynamically created query is just brain-dead as far as I...