CREATE PROCEDURE [dbo].[dynamic_example]
  @lastname varchar(50) = NULL,
  @firstname varchar(50) = NULL
AS

SELECT * from Users
WHERE (@lastname IS NULL OR users.lastname LIKE @lastname)
AND (@firstname IS NULL OR users.firstname LIKE @firstname)
GO