Yes, this table exist and have access as well. Thanks for pointing out about name, will keep in mind.

Thanks for pointing out . Here is my new code I am trying

Select

T1.[Company Name],

T1.[Company Number],

T1.[ABRF] as [ABRF_2018],

T2.[ABRF] as [ABRF_2017]

into [dbo].[ABRF] from [dbo].[ACAR Historical Data_2018] as T1

inner Join [dbo].[ACAR Historical Data_2017]...

***Part of the code(Its a really big code and wont be able to paste completely here****

USE [AccessTest]

GO

/****** Object: StoredProcedure [dbo].[SP_FlagTests_CY] Script Date: 2019-09-27 9:36:14 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER...

declare @abc varchar(50)

set @abc = 'Accesstest.dbo.[ Historical Data_' + (select cast(year(getdate()) - 2 as varchar(4))) + ']'

declare @query varchar(max)

set @query = '

if object_id(''AccessTest.dbo.ABC'') is not null...

Also, this is just part of the code and when I am running the complete Stored procedure I am getting this particular error:

Msg 207, Level 16, State 1, Procedure SP_FlagTests_CY,...

It was a really long code and i couldn't copy the code over here.

But here is the actual script :

ALTER PROCEDURE [dbo].[SP_SBC_CY]

AS

BEGIN

SET NOCOUNT ON;

declare @CYMinus1Table varchar(50), @CYMinus2Table varchar(50), @CYMinus3Table varchar(50)

set...

As per my understanding if table ABC already exist in a defined library it will delete it however my question is why it is giving me an error if table...