Values from the application that will be sent to the DB to do the lookup....

I have a table with 6 fields, and given 6 values, I have to find the row that matches at least 4 values - 5 or 6 are ok, too...

I tried that, but I couldn't see how thats done... is there a way I can move it? Or does it have to be done by an admin?

The query is this:

select * from nodes

where macaddress = '00-13-d3-b4-47-ab'

I can't save the plan, because its sql server 2000 - but basically it is something like this:

Select (0%) <- Book...

I did it ! I saw the first suggestion as the best one and the only reason I was having issues with that is because of the index.... so I...

Richard, unfortunately, when the parameters don't match, they will not be null - they might have other values in it, so the conditions inside where (@f1 is null or @f1...

Wow - genius solution and it works ! - But unfortunately, its not using my indexes anymore, and I have over 1 million rows - and growing 🙁

"Changing the name of the variables can't be the reason." - I figured that  - I guess it has something to do with using...

Thanks for all the helpfull info - but I'm not sure that was what was causing my slowdowns in the first place - when I changed it to a local...

ahh - I see - but isn't the convert taking it back to varchar ?

yes, it is faster - but I still don't get why changing the names would make it so much faster.... they are both varchar - the scenario is both the...

yes, but it is being passed in as varchar - so the local variable and the input paramters are both varchar...:-/