DECLARE @filter VARCHAR(100), @LogDate DATETIME

SET @LogDate = getdate()
 
SET NOCOUNT ON
 
set transaction isolation level read uncommitted
set lock_timeout 10000
 

BEGIN

	IF EXISTS (SELECT * FROM tempdb..sysobjects
	WHERE id = object_id(N'[tempdb]..[#TempLog1]'))
	DROP TABLE #TempLog1

	CREATE TABLE #TempLog1
	(LogDate datetime, ProcessInfo varchar(50),ErrorLog VARCHAR (1000))

	INSERT INTO #TempLog1
	EXEC('xp_readerrorlog')

	IF @filter IS NULL AND @LogDate IS NULL 
	 BEGIN
	  SELECT LogDate, ErrorLog 
	  FROM  #TempLog1
	  ORDER BY LogDate DESC
	 END
	ELSE IF @filter IS NOT NULL AND @LogDate IS NULL 
	 BEGIN
	  SELECT LogDate, ErrorLog  
	  FROM  #TempLog1
	  WHERE ErrorLog Like  '%'+@filter+'%'
	  ORDER BY LogDate DESC
	 END
	ELSE IF @filter IS NULL AND @LogDate IS NOT NULL 
	 BEGIN
	  SELECT LogDate, ErrorLog 
	  FROM  #TempLog1
	  WHERE LogDate BETWEEN CONVERT(VARCHAR(50), CAST(@LogDate AS DATETIME), 101)
		AND CONVERT(VARCHAR(50), CAST(@LogDate + 1 AS DATETIME), 101)
	  ORDER BY LogDate DESC
	 END
	ELSE --Both parameters have values
	 BEGIN
	  SELECT LogDate, ErrorLog 
	  FROM  #TempLog1
	  WHERE LogDate BETWEEN CONVERT(VARCHAR(50), CAST(@LogDate AS DATETIME), 101)
		AND CONVERT(VARCHAR(50), CAST(@LogDate + 1 AS DATETIME), 101)
	  AND ErrorLog Like '%'+@filter+'%'
	  ORDER BY LogDate DESC
	 END
END

DROP TABLE #TempLog1