Hi everyone,
I am writing SP and getting a error message for logic like this:

IF EXISTS (SELECT *FROM [tempdb].INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '#MainView___%') DROP TABLE #MainView

IF @State = ''
SELECT * INTO #MainView FROM main WHERE CONVERT(varchar, date, 101)=@Date
ELSE
SELECT * INTO #MainView FROM main WHERE CONVERT(varchar, date, 101)=@Date AND State=@State

It says that object #MainView already exists in database
What do I do wrong?
Thanks in advance