>>No, you do need to use parameterized approach. However, you may be running in parameters sniffing problem. If that's the case, addition OPTION (RECOMPILE) to the end of the query may fix the problem.
>
>So, SQL Server performs less with the parameterized approach. We just saw that in the new execution plan it would give. What do you recommand to keep the parameterized approach and keep the benefit of the optimized execution plan?
As I said, the problem we often ran into with parameters is called 'Parameter Sniffing' problem. There are several articles on this topic which you may want to read. Say, by Tibor K or by Erland S.
If it's not broken, fix it until it is.
My Blog