>The execution goes completely weird simply because I passed a parameter.
>
>Anyone can explain why the execution plan is showing a very complex plan simply because I pass my values as parameters?

Michel.....I'm assuming in the first query you're getting an index seek in the execution plan.

In the second one, are you also getting an index seek, plus some additional execution operators for "Compute Scalar" and "Constant Scan"?