Don't ask me how or why, but I've found a trick to avoid the RS request for a parameter related to a table name:

1. From the "Data" folder, press the...

Thank you for your help.

I tink I'm loosing the war ....

BR

Antonio

Thanks for your reply.

The query I use is this:

SELECT RILEVA.U_Emp AS Emp,

b.lastName + ' ' + b.firstName AS Nominativo,

RILEVA.U_Data AS Data,

RILEVA.U_Catt AS CodAtt,

RILEVA.U_Tipo AS Tipo,

RILEVA.U_Totale*60...

Very, Very useful.

How can I avoid the problem of 'ntext', 'text', 'image' fields when executing:

IF @ACT = 'INSERT' INSERT [DBO].[AUDIT_BTPRJ_COSTIIMP] SELECT *,'INSERT' ,GETDATE() FROM INSERTED

IF @ACT = 'DELETE' INSERT [DBO].[AUDIT_BTPRJ_COSTIIMP]...

Thanks Elliot and Jason.

I'll follow the EXEC ('......') method.

My intent was to find something to avoid to replicate the statements executed by a trigger in an other SP mainly because...