We currenlty use the following stored procedure:
PROCEDURE [dbo].[Proc_Customer] (@PosID int, @ZipCode int) AS
WHERE Running = 1
AND PosID = @PosID
AND ZipCode = @ZipCode
but we look for a solution for:
when the last AND value (ZipCode) is equal a certain value (example if = 0) then this AND request is not taken in account.
I hope the question is clear ...