In this blog we will be focusing on an easier part of the program. All we need to do in the stored procedure usp_12DeletePreviousOrder is to write a few statements that delete all of the data from five tables.

It is a good time to write this one because it cleans up the tables and it makes it easier to debug our code if we only looking at the current import. We can go ahead and run the stored procedure that runs all of the other stored procedures when we are testing our code.

DELETE FROM [dbo].[02DetailBulkInsert]
DELETE FROM [dbo].[01HeaderBulkInsert]
DELETE FROM [dbo].[Books]
DELETE FROM [dbo].[Orders]
DELETE FROM [dbo].[Suppliers]