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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141
| CREATE TABLE #Event (IDEvent Int Identity(1,1),
IdTypeEvent Int,
TimeEvent DateTime,
)
ALTER TABLE #Event ADD CONSTRAINT [IDEvent] PRIMARY KEY CLUSTERED
(
[IDEvent] ASC
)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/08/2011 08:45:25',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/08/2011 08:45:28',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 121, Convert(DATETIME,'07/08/2011 08:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/08/2011 08:47:12',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/08/2011 08:47:15',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 17, Convert(DATETIME,'07/08/2011 08:48',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 98, Convert(DATETIME,'07/08/2011 08:50',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 122, Convert(DATETIME,'07/08/2011 08:53',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/08/2011 08:54:27',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/08/2011 08:54:30',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1, Convert(DATETIME,'07/08/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 14, Convert(DATETIME,'07/08/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 31, Convert(DATETIME,'07/08/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 12, Convert(DATETIME,'07/08/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/08/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/08/2011 08:57:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/08/2011 08:57:49',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1, Convert(DATETIME,'07/08/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 14, Convert(DATETIME,'07/08/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 31, Convert(DATETIME,'07/08/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 12, Convert(DATETIME,'07/08/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/08/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 47, Convert(DATETIME,'07/13/2011 08:45:25',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 47, Convert(DATETIME,'07/13/2011 08:45:28',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 121, Convert(DATETIME,'07/13/2011 08:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/13/2011 08:47:12',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/13/2011 08:47:15',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 17, Convert(DATETIME,'07/13/2011 08:48',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 98, Convert(DATETIME,'07/13/2011 08:50',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 122, Convert(DATETIME,'07/13/2011 08:53',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/13/2011 08:54:27',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/13/2011 08:54:30',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1, Convert(DATETIME,'07/13/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 14, Convert(DATETIME,'07/13/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 31, Convert(DATETIME,'07/13/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 12, Convert(DATETIME,'07/13/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/13/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/13/2011 08:57:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/13/2011 08:57:49',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1, Convert(DATETIME,'07/13/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 14, Convert(DATETIME,'07/13/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 31, Convert(DATETIME,'07/13/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 59, Convert(DATETIME,'07/13/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 59, Convert(DATETIME,'07/13/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 69, Convert(DATETIME,'07/12/2011 08:45:25',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 69, Convert(DATETIME,'07/12/2011 08:45:28',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 69, Convert(DATETIME,'07/12/2011 08:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/12/2011 08:47:12',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/12/2011 08:47:15',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 17, Convert(DATETIME,'07/12/2011 08:48',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 98, Convert(DATETIME,'07/12/2011 08:50',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 122, Convert(DATETIME,'07/12/2011 08:53',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/12/2011 08:54:27',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/12/2011 08:54:30',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1, Convert(DATETIME,'07/12/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 14, Convert(DATETIME,'07/12/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 31, Convert(DATETIME,'07/12/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 12, Convert(DATETIME,'07/12/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/12/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/12/2011 08:57:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/12/2011 08:57:49',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1, Convert(DATETIME,'07/12/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 14, Convert(DATETIME,'07/12/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 31, Convert(DATETIME,'07/12/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 12, Convert(DATETIME,'07/12/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/12/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/11/2011 08:45:25',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/11/2011 08:45:28',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1121, Convert(DATETIME,'07/11/2011 08:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/11/2011 08:47:12',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/11/2011 08:47:15',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 117, Convert(DATETIME,'07/11/2011 08:48',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 198, Convert(DATETIME,'07/11/2011 08:50',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1122, Convert(DATETIME,'07/11/2011 08:53',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/11/2011 08:54:27',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/11/2011 08:54:30',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 11, Convert(DATETIME,'07/11/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 114, Convert(DATETIME,'07/11/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 131, Convert(DATETIME,'07/11/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 112, Convert(DATETIME,'07/11/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 113, Convert(DATETIME,'07/11/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/11/2011 08:57:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/11/2011 08:57:49',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 11, Convert(DATETIME,'07/11/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 114, Convert(DATETIME,'07/11/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 131, Convert(DATETIME,'07/11/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 112, Convert(DATETIME,'07/11/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 113, Convert(DATETIME,'07/11/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 147, Convert(DATETIME,'07/10/2011 08:45:25',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 147, Convert(DATETIME,'07/10/2011 08:45:28',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1121, Convert(DATETIME,'07/10/2011 08:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 42, Convert(DATETIME,'07/10/2011 08:47:12',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 3, Convert(DATETIME,'07/10/2011 08:47:15',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 117, Convert(DATETIME,'07/10/2011 08:48',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 198, Convert(DATETIME,'07/10/2011 08:50',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1122, Convert(DATETIME,'07/10/2011 08:53',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/10/2011 08:54:27',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/10/2011 08:54:30',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 11, Convert(DATETIME,'07/10/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 114, Convert(DATETIME,'07/10/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 131, Convert(DATETIME,'07/10/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 112, Convert(DATETIME,'07/10/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 113, Convert(DATETIME,'07/10/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/10/2011 08:57:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/10/2011 08:57:49',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 11, Convert(DATETIME,'07/10/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 114, Convert(DATETIME,'07/10/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 131, Convert(DATETIME,'07/10/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 159, Convert(DATETIME,'07/10/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 159, Convert(DATETIME,'07/10/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 169, Convert(DATETIME,'07/09/2011 08:45:25',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 169, Convert(DATETIME,'07/09/2011 08:45:28',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 169, Convert(DATETIME,'07/09/2011 08:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/09/2011 08:47:12',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/09/2011 08:47:15',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 117, Convert(DATETIME,'07/09/2011 08:48',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 198, Convert(DATETIME,'07/09/2011 08:50',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 1122, Convert(DATETIME,'07/09/2011 08:53',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/09/2011 08:54:27',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/09/2011 08:54:30',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 11, Convert(DATETIME,'07/09/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 114, Convert(DATETIME,'07/09/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 131, Convert(DATETIME,'07/09/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 112, Convert(DATETIME,'07/09/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 113, Convert(DATETIME,'07/09/2011 08:55:42',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 142, Convert(DATETIME,'07/09/2011 08:57:46',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 13, Convert(DATETIME,'07/09/2011 08:57:49',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 11, Convert(DATETIME,'07/09/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 114, Convert(DATETIME,'07/09/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 131, Convert(DATETIME,'07/09/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 112, Convert(DATETIME,'07/09/2011 08:59:59',121)
INSERT INTO #Event (IdTypeEvent,TimeEvent) SELECT 113, Convert(DATETIME,'07/09/2011 08:59:59',121) |
Partager