what we are utilmately trying to do is run this procedure on a daily or weekly basis to pull in the actual price of our material to load into a reporting system. Once this table is created, we then import this data into a more permanent dimensional table that holds all the facts for a dimensional cube. So when this SPROC runs, it would just need to clear what is in the table and refresh with updated data.
in that case, it seems like the table must exist, but the sproc needs to DELETE FROM dbo.tblPlexActualPrice or TRUNCATE TABLE dbo.tblPlexActualPrice, instead of than destroy and create the table?
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!