BusStateParser/sqlCreateStoredProcedures.sql at master · bbafford/BusStateParser · GitHub

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
use buswarelogs
go
IF EXISTS ( SELECT *
            FROM   sysobjects
            WHERE  id = object_id(N'[dbo].[InsertBusStateEntry]')
                   and OBJECTPROPERTY(id, N'IsProcedure') = 1 )
BEGIN
    DROP PROCEDURE [dbo].[InsertBusStateEntry]
END
go


create procedure InsertBusStateEntry
(	@BusToolsVersion varchar(21),
	@RouteID varchar(10),
	@StopSequence int,
	@BusID varchar (8),
	@EventTIme varchar(20),
	@Backdoorentry int,
	@FrontDoorEntry int,
	@FrontDoorExit int,
	@BackDoorExit int,
	@operatorid varchar(8),
	@Latitude decimal(10,8),
	@Longitude decimal (10,8),
	@Filename varchar(50),
	@eventtype int,
	@Workstatus int
	)
As
begin


	insert into [dbo].BusState (BusToolsVersion,
	RouteID ,
	StopSequence ,
	BusID ,
	EventTIme ,
	Backdoorentry ,
	FrontDoorEntry ,
	FrontDoorExit ,
	BackDoorExit ,
	operatorid,
	Latitude ,
	Longitude,
	BusStateFile,
	EventType,
	Workstatus

	)
	values
	(@BusToolsVersion,
	@RouteID ,
	@StopSequence ,
	@BusID ,
	@EventTIme ,
	@Backdoorentry ,
	@FrontDoorEntry ,
	@FrontDoorExit ,
	@BackDoorExit ,
	@operatorid,
	@Latitude ,
	@Longitude,
	@filename,
	@eventtype,
	@workstatus
	)
end
go