r, 5, 6) AS PassportNumberConductorsVIEW Conductors1View ASIDConductor, RTRIM (LastName) + + SUBSTRING (FirstName, 1,1) + . Raquo; + SUBSTRING (Patronymic, 1,1) + . Raquo; AS Conductor, (LastName) AS LastName, RTRIM (FirstName) AS FirstName, RTRIM (Patronymic) AS Patronymic, Birthday, (PassportNumber, 1, 4) + + SUBSTRING (PassportNumber, 5, 6) AS PassportNumberConductorsVIEW DriversView ASIDDriver, RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . Raquo; + SUBSTRING (Patronymic, 1, 1) + . Raquo; AS Driver, (LastName) AS LastName, RTRIM (FirstName) AS FirstName, RTRIM (Patronymic) AS Patronymic, Birthday, (PassportNumber, 1, 4) + + SUBSTRING (PassportNumber, 5, 6) AS PassportNumber, (DrivingLicence, 1, 4) + + SUBSTRING (DrivingLicence, 5, 6) AS DrivingLicence,
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Drivers.IDBus=Buses.IDBus) AS BusDriversVIEW Drivers1View ASIDDriver, RTRIM (LastName ) + + SUBSTRING (FirstName, 1, 1) + . Raquo; + SUBSTRING (Patronymic, 1, 1) + . Raquo; AS Driver, (LastName) AS LastName, RTRIM (FirstName) AS FirstName, RTRIM (Patronymic) AS Patronymic, Birthday, (PassportNumber, 1, 4) + + SUBSTRING (PassportNumber, 5, 6) AS PassportNumber, (DrivingLicence, 1, 4) + + SUBSTRING (DrivingLicence, 5, 6) AS DrivingLicence,
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Drivers.IDBus=Buses.IDBus) AS BusDriversVIEW DistanceView AS
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Distance.IDBus=Buses.IDBus) AS Bus ,, DistanceDistanceVIEW RevenueView AS
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . + SUBSTRING (Patronymic, 1, 1) + . FROM Conductors WHERE Revenue.IDConductor=Conductors.IDConductor) AS Conductor ,, PlannedRevenue, ActualRevenue,
(SELECT RTRIM (NameRoute) FROM Routes WHERE Revenue.IDRoute=Routes.IDRoute) AS NameRoute,
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . + SUBSTRING (Patronymic, 1, 1) + . FROM Drivers WHERE Revenue.IDDriver=Drivers.IDDriver) AS Driver,
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Buses.IDBus=Revenue.IDBus) AS Bus, RevenueVIEW Revenue1View AS
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . + SUBSTRING (Patronymic, 1, 1) + . FROM Conductors WHERE Revenue.IDConductor=Conductors.IDConductor) AS Conductor ,, PlannedRevenue, ActualRevenue, IDConductor,
(SELECT RTRIM (NameRoute) FROM Routes WHERE Revenue.IDRoute=Routes.IDRoute) AS NameRoute,
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . + SUBSTRING (Patronymic, 1, 1) + . FROM Drivers WHERE Revenue.IDDriver=Drivers.IDDriver) AS Driver,
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Buses.IDBus=Revenue.IDBus) AS Bus, RevenueVIEW WorkedTimeView AS
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1,1) + . + SUBSTRING (Patronymic, 1,1) + . FROM Drivers WHERE Drivers.IDDriver=WorkedTime.IDDriver) AS Driver ,, Date,
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . + SUBSTRING (Patronymic, 1, 1) + . FROM Conductors WHERE Conductors.IDConductor=WorkedTime.IDConductor) AS Conductor,
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Buses.IDBus=WorkedTime.IDBus) AS Bus,
(SELECT RTRIM (NameRoute) FROM Routes WHERE WorkedTime.IDRoute=Routes.IDRoute) AS NameRoute ,, ActualTrip, Distance, SpendFuel, Change, ExitInRoute, Reserve, Stopping, Repairs, TO2WorkedTimeVIEW WorkedTime1View AS
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1,1) + . + SUBSTRING (Patronymic, 1,1) + . FROM Drivers WHERE Drivers.IDDriver=WorkedTime.IDDriver) AS Driver ,, Date, IDDriver, IDConductor,
(SELECT RTRIM (LastName) + + SUBSTRING (FirstName, 1, 1) + . + SUBSTRING (Patronymic, 1, 1) + . FROM Conductors WHERE Conductors.IDConductor=WorkedTime.IDConductor) AS Conductor,
(SELECT RTRIM (Brend) + ( + RTRIM (StateNumber) + ) FROM Buses WHERE Buses.IDBus=WorkedTime.IDBus) AS Bus,
(SELECT RTRIM (NameRoute) FROM Routes WHERE WorkedTime.IDRoute=Routes.IDRoute) AS NameRoute ,, ActualTrip, Distance, SpendFuel, Change, ExitInRoute, Reserve, Stopping, Repairs, TO2WorkedTimeVIEW RoutesView ASRTRIM (NameRoute ) AS NameRoute, RTRIM (Direction) AS Direction, Length, Trips, Revenue, Fuel, ExitTime, ReturnTimeRoutes
----//Створення збережених процедур//-----
---- Процедура додавання нового автобуса -----
- П...
