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
XO4Y BCE 3HATb,YMETb,IMETb!