Four Year Starter ? <| sep |> Let ' s audit the states everyone knew they were struggling in PA , FL , OH and VA <| sep |> Here ' s a more straight forward answer for you there ' s no way to just do free play with a full team . You can launch a custom game and have only your team in there , make it timeless and just pass the ball around . There you go . <| sep |> the point is that you are inserting data in a fact table for a theater that does not exists in the theater dimension . Your query looks ok on the select part and that should not heapen but make sure to list the columns of the fact table in the insert into . It might be that theaterid is being loaded by some other column basically change thisINSERT INTO fact SELECT TIMEID , clientid , productionid , theatreid , Trowid , totalto something like INSERT INTO fact TIMEID , clientid , productionid , theatreid , Trowid , total SELECT TIMEID , clientid , productionid , theatreid , Trowid , total