Stored Procedure Parameters problem - Takes too long

[camaleonCHILE]

Hi, I've some Sql code with a INNER JOIN for two tables. I put this code inside a Stored Procedure. This SP has 2 parameters (varchar both) that work like filters. When I run the SP sending the parameters, this takes up to 2 minutes for the results. When I execute the same code but now with 2 variables with the same type and value than the parameters below, the results appear in 3-7 seconds.

I saw both execution plans in then Query Analyzer(the code with parameters and with variables), and they are different.

¿ what can I do ? ( I trust in you, masters)

thanks in advance.

Regards

 

[SQLDenis]

looka ta the execution plan any conversions going on? can you post some code

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/