The template from EM doesn't come from the Query Analyzer templates what I can see. It must be from somewhere else.

/Regards Anders

AW

This sp executes a lot. It's used within a public travel site with about 12 thousand sessions a day. This sp executes more than once a minute. The time for...

I forgot to mention, Of course I declared the table variable in the beginning of the sp like :

Declare @TmpTb table (id int, col1 char(5), col2 char(5))

This is only...