Manipulating Error Logs

DECLARE @temptable TABLE(
 LogDate DATETIME,
 ProcessInfo NVARCHAR(MAX),
 [Text] NVARCHAR(MAX)
 )

INSERT INTO @temptable
Exec sp_readerrorlog 0,1

--DROP TABLE @temptable

SELECT * FROM @temptable where DATEDIFF(DAY,[LogDate], GETDATE()) = 0