Hey there,

I looking for a way to dynamicly add a filter to my statment without using dynamic SQL.

I want to select all computers from a table, but when I pass a computer id to the sp, I want to get only this computer.

Actually I try this on

DECLARE @ComputerFilter AS INT
DECLARE @ComputerID AS INT

SELECT Computername 
FROM   Computer
WHERE  (ComputerID = @ComputerID) OR (@ComputerFilter IS NULL))

But this is 100 times slow then this statment and tooks as long as SELECT * FROM Computer

SELECT Computername 
FROM   Computer
WHERE  ComputerID = @ComputerID

Is there a way to speed this statment up or is there any other way to solve this problem with one select und without dynamic sql?