Hello
I finally found the result:
This is the answer. I changed the beginning of the stored procedure when I declare the variable from :
SET

Hello
Do u have advices about my problème?

Thank you for your answers.

After testing disable/enable vs drop/create foreign keys I had the same performance.
Finally we prefered the 'drop/create' 

Thank you

Hello everyone 

I want to give you news of my project.

I was able to set up as many foreign keys as I could.

I now want to...

Thks Phil for your help. 🙂

I have this solution too.

select requestid,

min(case when eventname = 'REVIEWED' then eventdate end) as eventdate,

...