Untitled
unknown
sqlserver
2 years ago
1.2 kB
3
Indexable
insert into Orders(OrderID, Date, CustomerID, Amount)
values
('Or001', '12/05/2000', 'C01'),
('Or002', '25/05/2000', 'C02'),
('Or003', '25/05/2000', 'C03'),
('Or004', '25/05/2000', 'C04'),
('Or005', '26/05/2000', 'C05'),
('Or006', '02/06/2000', 'C06'),
('Or007', '22/06/2000', 'C07'),
('Or008', '25/06/2000', 'C08'),
('Or009', '15/08/2000', 'C09'),
('Or010', '30/09/2000', 'C10'),
('Or011', '27/12/2000', 'C11'),
('Or012', '27/12/2000', 'C12')
insert into OrderItems(OrderID, ProductCode, Quantity, SellPrice)
values
('Or001', 'P01', '5', '12'),
('Or001', 'P05', '10', '300'),
('Or002', 'P03', '4', '13'),
('Or003', 'P02', '20', '16'),
('Or004', 'P03', '3', '13'),
('Or004', 'P04', '10', '120'),
('Or005', 'P05', '10', '309'),
('Or005', 'P06', '15', '46.6'),
('Or005', 'P07', '20', '70'),
('Or006', 'P04', '10', '120'),
('Or007', 'P04', '20', '125'),
('Or008', 'P01', '2', '11.5'),
('Or008', 'P02', '20', '16'),
('Or009', 'P02', '25', '17'),
('Or010', 'P01', '25', '11.5'),
('Or011', 'P01', '20', '12'),
('Or011', 'P02', '20', '17'),
('Or012', 'P01', '20', '12'),
('Or012', 'P02', '10', '16.5'),
('Or012', 'P03', '1', '13.5')