Thanks for the information but i dont what the table to be a temporary table in the tempdb database. I need it to appear in the ConstarOLAP_PROPHIX_FactDB where the SPROC is running