IF OBJECT_ID('tempdb..#tempStoreData') IS NOT NULL DROP TABLE #tempStoreData CREATE TABLE #tempStoreData ( [RowNumber] INT IDENTITY(1,1), [StoreCode] INT, [OpeningBalance] FLOAT )