SELECT * FROM bm_Clients WHERE (CompanyKey = @CompanyKey OR @CompanyKey IS NULL) AND (ClientKey = @ClientKey OR @ClientKey IS NULL)>This stored proc takes 2 optional params.
> >CREATE PROCEDURE bm_GetClients > @CompanyKey INT = NULL, > @ClientKey INT = NULL > >AS >BEGIN > > SELECT * > FROM bm_Clients > WHERE CompanyKey = ISNULL(@CompanyKey, CompanyKey) OR > ClientKey = ISNULL(@ClientKey, ClientKey) > >END >>
>DECLARE @CompanyKey INT >DECLARE @ClientKey INT >SET @CompanyKey = 2 >SET @ClientKey = 5 > >EXEC bm_GetClients >EXEC bm_GetClients @ClientKey >EXEC bm_GetClients @CompanyKey, @ClientKey >EXEC bm_GetClients @CompanyKey >>