@Gail Shaw: Thank you for your advice.

Here is the table for the problem:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#Patient','U') IS NOT NULL

...