INSERT INTO Dudek.DIM_PRODUCT VALUES(1, 'Product', 0.00, 'Black', 'Wheels', 'Components', 300, 5, 1);
Msg 2627, Level 14, State 1, Line 190
Violation of PRIMARY KEY constraint 'PK__DIM_PROD__B40CC6EDB061C2D6'. Cannot insert du-plicate key in object 'Dudek.DIM_PRODUCT'. The duplicate key value is (1).
The statement has been terminated.

INSERT INTO Dudek.DIM_CUSTOMER VALUES(11000, 'Jan', 'Nowak', 'Mr.', 'City', 'Australia', 'AU', 'Pacific');
Msg 2627, Level 14, State 1, Line 191
Violation of PRIMARY KEY constraint 'PK__DIM_CUST__A4AE64B8DCABA1EA'. Cannot insert du-plicate key in object 'Dudek.DIM_CUSTOMER'. The duplicate key value is (11000).
The statement has been terminated.

INSERT INTO Dudek.DIM_SALESPERSON VALUES(274, 'Jan', 'Nowak', 'Mr.', 'M', 'US' , 'North America');
Msg 2627, Level 14, State 1, Line 192
Violation of PRIMARY KEY constraint 'PK__DIM_SALE__7A591C18123FC9DA'. Cannot insert du-plicate key in object 'Dudek.DIM_SALESPERSON'. The duplicate key value is (274).
The statement has been terminated.



INSERT INTO Dudek.FACT_SALES VALUES(5, 11000, 274, 20131201,20131208, 1, 34.99, 0.00);
Msg 547, Level 16, State 0, Line 195
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__FACT_SALE__Produ__52793849". The conflict occurred in database "master", table "Dudek.DIM_PRODUCT", column 'ProductID'.
The statement has been terminated.

INSERT INTO Dudek.FACT_SALES VALUES(1, 1, 274, 20131201,20131208, 1, 34.99, 0.00);
Msg 547, Level 16, State 0, Line 196
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__FACT_SALE__Custo__51851410". The conflict occurred in database "master", table "Dudek.DIM_CUSTOMER", column 'CustomerID'.
The statement has been terminated.

INSERT INTO Dudek.FACT_SALES VALUES(1, 11000, 1, 20131201,20131208, 1, 34.99, 0.00);
Msg 547, Level 16, State 0, Line 197
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__FACT_SALE__Sales__536D5C82". The conflict occurred in database "master", table "Dudek.DIM_SALESPERSON", column 'SalesPersonID'.
The statement has been terminated.