USE SALES
GO

/*Insert report*/
INSERT INTO REPORT([Name], XmlFile, XslFile, Active) VALUES ('Daily Sales Activity', '\template\temdailysales.xml', 'dailysales.xsl', 'Y')
GO

/*Insert Manager */
INSERT INTO MANAGER(ManagerId, FirstName, LastName, Email,[Password], Active) VALUES (1,'Johnny', 'Smithe', 'no@no.com', 'system', 'Y')
GO
INSERT INTO MANAGER(ManagerId, FirstName, LastName, Email,[Password], Active) VALUES (2,'Karen',  'Xythe', 'no@no.com', 'system', 'Y')
GO
INSERT INTO MANAGER(ManagerId, FirstName, LastName, Email,[Password], Active) VALUES (3,'Brett',  'Heath', 'no@no.com', 'system', 'Y')
GO
INSERT INTO MANAGER(ManagerId, FirstName, LastName, Email, [Password], Active) VALUES (4,'Gabby',  'Banks', 'no@no.com', 'system', 'Y')
GO
INSERT INTO MANAGER(ManagerId, FirstName, LastName, Email, [Password], Active) VALUES (5,'Faye',   'Jones', 'no@no.com', 'system', 'Y')
GO
INSERT INTO MANAGER(ManagerId, FirstName, LastName, Email, [Password], Active) VALUES (6,'Joh',    'Boy', 'no@no.com', 'system', 'Y')
GO

/*Insert Locations*/
INSERT INTO LOCATION(LocationID, ManagerId, Number, [Name], City, State, Zip) VALUES (1000, 1, 'C-100', 'BURGER SHOP C-100', 'PHOENIX', 'AZ', '99999')
GO
INSERT INTO LOCATION(LocationID, ManagerId, Number, [Name], City, State, Zip) VALUES (1001, 2, 'C-200', 'BURGER SHOP C-200', 'GIG HARBOR', 'WA', '99999')
GO
INSERT INTO LOCATION (LocationID, ManagerId, Number, [Name], City, State, Zip) VALUES (1002, 3, 'C-300', 'BURGER SHOP C-300', 'NEW YORK', 'YK', '99999')
GO

/*Insert Activity*/
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1000, '1/1/2001', 10000, 32.5, 1)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1000, '1/3/2001', 20000, 32.8, 2)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1001, '2/11/2001', 70000, 32.5, 9)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1001, '4/15/2001', 6000, 32.5, 23)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1002, '4/13/2001', 40000, 32.5, 51)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1002, '5/11/2001', 100, 32.5, 9)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1002, '5/22/2001', 40000, 32.5, 5)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1001, '3/9/2001', 60000, 32.5, 6)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1001, '3/14/2001', 80000, 32.5, 7)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1000, '2/15/2001', 90000, 32.5, 8)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1000, '5/3/2001', 20000, 32.5, 19)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1002, '2/2/2001', 40000, 32.5, 19)
GO
INSERT INTO Activity (LocationID, DateEntered, Sales, Margin, NewAccounts) VALUES (1002, '3/11/2001', 10000, 32.5, 14)
GO
