tstagliano (7/9/2013)
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?
Lowell