IF OBJECT_ID('tempdb..#tempStoreData') IS NOT NULL DROP TABLE #tempStoreData CREATE TABLE #tempStoreData ( [RowNumber] INT IDENTITY(1,1), [StoreCode] INT, TransactionDate VARCHAR(50), TransactionNumber VARCHAR(100), TransactionAmount FLOAT, TransactionStatus VARCHAR(100), TransactionRemarks VARCHAR(250) )