Hi,<BR><BR>I have a weird problem in my stored procedure. I have a relatively large query (4 queries, 3 unions each). And in each of these queries I must check against a user number. The problem is that if I write the user number directly in the query, the stored procedure takes less than a second to resolve. If I assign the value to a variable @user_id, and replace all IDs by this variable, it takes 3 to 4 seconds to run my query.<BR><BR>Have any one of you seen this problem before ?<BR><BR>Regards,<BR>Jebby