Hi,

I have the same problem and I use your solution.

IT'S WORK !

Thanks for all 🙂

To resume the solution is :

- Stop the Report Server Service

- TRUNCATE TABLE...

Perfect !

Thnaks U very much ! 😀

And I want that ContactID and AdressID is only (Primary Key), as that :

C001 - AD001 - AC001 - ACCOUNT 001

C002 - AD002 - AC002 - ACCOUNT 002

C003 - AD003...

Okay, but with your solution I have a problem.

ContactID and AdressID is my Primary Kay.

So with this solution, I have this Result :

C001 - AD001 - AC001 - ACCOUNT 001

C001...

Thanks for your reply.

As that :

ALTER TRIGGER [dbo].[TI_Creation_Contact_dansSLX]

ON [dbo].[_IMPORT_FILES_CONTACTS]

AFTER INSERT

AS

BEGIN

SELECT ACCOUNTID,

ACCOUNT,

FROMInserted

BEGIN

...

Hi Eirikur Eiriksson,

Thanks for your solution but with my Reporting it's not appropriate to create a Temporary table

But Thanks 🙂

Sean Pearce, I like you !

You're soultion is good and...

Hi Eirikur,

Thanks for your reply.

But, I do not think that answers my problem because I don't master on my parameter.

This request comes of Reporting, and the parameter is a choice...

Thanks for this answer.

It's what I needed 😉

Hello,

I just want to connect my server with a SQL script to not run twenty times the same manipulation "Login, database engine, my server connect" every morning.

I would like to...