-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathBackroads SQL Code.txt
89 lines (85 loc) · 4.71 KB
/
Backroads SQL Code.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
DECLARE @countingvariable INT
SET @countingvariable = 1
WHILE (@countingvariable <= 4968)
BEGIN
INSERT INTO dbo.Customer (CustomerID, CustomerFirstName, CustomerLastName, CustomerType, CustomerAddressLine1, CustomerAddressLine2, CustomerCity, CustomerState, CustomerZIP, CustomerRegion)
VALUES (
CAST(RAND()*9999 AS INT),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CAST(RAND()*(3)+1 AS INT),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + ' St.',
'Apt. ' + CAST(CAST(RAND()*(20) AS INT) AS nvarchar),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CAST(RAND()*(99999) AS INT),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT))
);
SET @countingvariable = @countingvariable + 1
END;
DECLARE @everyvariable INT
SET @everyvariable = 1
WHILE (@everyvariable <= 4968)
BEGIN
INSERT INTO dbo.Fuel (FuelID, Fuelname, FuelPriceDollarstoGallons)
VALUES (
CAST(RAND()*9999 AS INT),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CAST(RAND()*(10)+1 AS INT)
);
SET @everyvariable = @everyvariable + 1
END;
DECLARE @definevariable INT;
SET @definevariable = 1;
DECLARE @trucktype NVARCHAR(25);
SET @trucktype = CASE WHEN FLOOR(RAND(CHECKSUM(NEWID()))*2)+1=1 THEN 'ram' WHEN FLOOR(RAND(CHECKSUM(NEWID()))*2)+1=2 THEN 'chevrolet' ELSE 'chevrolet' END;
WHILE (@definevariable <= 4968)
BEGIN
INSERT INTO dbo.Truck (TruckID, TruckName, TruckType, TruckPriceDollars)
VALUES (
CAST(RAND()*9999 AS INT),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
@trucktype,
CAST(RAND()*(10000)+1000 AS INT)
);
SET @definevariable = @definevariable + 1
SET @trucktype = CASE WHEN FLOOR(RAND(CHECKSUM(NEWID()))*2)+1=1 THEN 'ram' WHEN FLOOR(RAND(CHECKSUM(NEWID()))*2)+1=2 THEN 'chevrolet' ELSE 'chevrolet' END;
END;
DECLARE @daysvariable INT
SET @daysvariable = 1
DECLARE @routetype NVARCHAR(25)
SET @routetype = CASE WHEN FLOOR(RAND(CHECKSUM(NEWID()))*4)+1=2 THEN 'backroad' ELSE 'interstate' END;
WHILE (@daysvariable <= 4968)
BEGIN
INSERT INTO dbo.TruckRoute(TruckRouteID, TruckRouteName, TruckRouteType, TruckRouteStartCity, TruckRouteEndCity, TruckRouteMileLength, TruckRouteFuelUsageGallons)
VALUES (
CAST(RAND()*9999 AS INT),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
@routetype,
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)) + CHAR(CAST(RAND()*(122-97)+97 AS INT)),
CAST(RAND()*9999 AS INT),
CAST(RAND()*(10)+1 AS INT)
);
SET @daysvariable = @daysvariable + 1
SET @routetype = CASE WHEN FLOOR(RAND(CHECKSUM(NEWID()))*4)+1=2 THEN 'backroad' ELSE 'interstate' END;
END;
DECLARE @kuskvariable INT
SET @kuskvariable = 1
DECLARE @deadvariable DATETIME
SET @deadvariable = CONVERT(DATETIME, RAND()*9999);
WHILE (@kuskvariable <= 4968)
BEGIN
INSERT INTO dbo.TrucktoCustomer(TrucktoCustomerID, TrucktoCustomerDate, TrucktoCustomerTruckRouteID, TrucktoCustomerTruckID, TrucktoCustomerCustomerID, TrucktoCustomerFuelID, TrucktoCustomerRevenue)
VALUES (
@kuskvariable,
@deadvariable,
CAST(RAND()*9999 AS INT),
CAST(RAND()*9998 AS INT),
CAST(RAND()*9997 AS INT),
CAST(RAND()*9996 AS INT),
CAST(RAND()*9995 AS INT)
);
SET @kuskvariable = @kuskvariable + 1
SET @deadvariable = CONVERT(DATETIME, RAND()*9999)
END;