数据处理所需的SQL SP。 [英] SQL SP required for data processing.
本文介绍了数据处理所需的SQL SP。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的,
我在sql server中有大量的记录。
我想创建SP或视图,将数据分成15分钟和在每15分钟后,它会在相关的15分钟记录中添加其他列值后为我提供1条记录。
Dear all,
I have bulk of record in sql server.
I want to create SP or view which will give be data into the chunks of 15 mins and for every 15 mins it will provide me 1 record after adding other column values in associated 15 mins records.
推荐答案
Vehicle_DateTime Transection Type Flag
6/30/12 3:12 PM 2 1
6/30/12 3:12 PM 2 1
6/30/12 3:12 PM 2 1
6/30/12 3:12 PM 2 1
6/30/12 3:12 PM 4 1
6/30/12 3:12 PM 4 1
6/30/12 3:13 PM 2 1
6/30/12 3:13 PM 2 1
6/30/12 3:13 PM 2 1
6/30/12 3:13 PM 2 1
6/30/12 3:13 PM 2 1
6/30/12 3:13 PM 2 1
6/30/12 3:14 PM 2 1
6/30/12 3:14 PM 2 1
6/30/12 3:14 PM 2 1
6/30/12 3:14 PM 2 1
6/30/12 3:14 PM 3 1
6/30/12 3:14 PM 3 1
6/30/12 3:14 PM 2 1
6/30/12 3:14 PM 2 1
6/30/12 3:15 PM 2 1
6/30/12 3:15 PM 2 1
6/30/12 3:15 PM 2 1
6/30/12 3:15 PM 2 1
6/30/12 3:15 PM 2 1
6/30/12 3:16 PM 3 1
6/30/12 3:16 PM 3 1
6/30/12 3:16 PM 2 1
6/30/12 3:17 PM 2 1
6/30/12 3:17 PM 2 1
6/30/12 3:18 PM 2 1
6/30/12 3:18 PM 2 1
6/30/12 3:18 PM 2 1
6/30/12 3:18 PM 2 1
6/30/12 3:18 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 3 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:19 PM 2 1
6/30/12 3:20 PM 2 1
6/30/12 3:20 PM 2 1
6/30/12 3:20 PM 2 1
6/30/12 3:20 PM 2 1
6/30/12 3:20 PM 2 1
6/30/12 3:21 PM 2 1
6/30/12 3:21 PM 2 1
6/30/12 3:21 PM 2 1
6/30/12 3:21 PM 2 1
6/30/12 3:22 PM 2 1
6/30/12 3:22 PM 2 1
6/30/12 3:22 PM 2 1
6/30/12 3:23 PM 3 1
6/30/12 3:23 PM 2 1
6/30/12 3:23 PM 2 1
6/30/12 3:23 PM 2 1
6/30/12 3:23 PM 2 1
6/30/12 3:24 PM 2 1
6/30/12 3:24 PM 2 1
6/30/12 3:24 PM 2 1
6/30/12 3:25 PM 2 1
6/30/12 3:25 PM 2 1
6/30/12 3:25 PM 2 1
6/30/12 3:25 PM 2 1
6/30/12 3:25 PM 2 1
6/30/12 3:26 PM 2 1
6/30/12 3:26 PM 2 1
6/30/12 3:26 PM 2 1
6/30/12 3:26 PM 2 1
6/30/12 3:26 PM 2 1
6/30/12 3:26 PM 2 1
6/30/12 3:27 PM 2 1
6/30/12 3:27 PM 2 1
6/30/12 3:27 PM 4 1
6/30/12 3:27 PM 2 1
6/30/12 3:27 PM 2 1
6/30/12 3:27 PM 2 1
6/30/12 3:27 PM 2 1
6/30/12 3:28 PM 2 1
6/30/12 3:28 PM 2 1
6/30/12 3:28 PM 2 1
6/30/12 3:28 PM 2 1
6/30/12 3:29 PM 2 1
6/30/12 3:29 PM 3 1
6/30/12 3:29 PM 2 1
6/30/12 3:29 PM 2 1
6/30/12 3:29 PM 2 1
6/30/12 3:30 PM 2 1
6/30/12 3:30 PM 2 1
6/30/12 3:30 PM 2 1
6/30/12 3:30 PM 2 1
6/30/12 3:30 PM 2 1
6/30/12 3:30 PM 2 1
6/30/12 3:31 PM 2 1
6/30/12 3:31 PM 2 1
6/30/12 3:31 PM 2 1
6/30/12 3:32 PM 5 1
6/30/12 3:32 PM 2 1
6/30/12 3:32 PM 2 1
6/30/12 3:32 PM 2 1
6/30/12 3:33 PM 2 1
6/30/12 3:33 PM 2 1
6/30/12 3:34 PM 2 1
6/30/12 3:34 PM 2 1
6/30/12 3:35 PM 2 1
6/30/12 3:35 PM 2 1
6/30/12 3:35 PM 2 1
6/30/12 3:35 PM 2 1
6/30/12 3:36 PM 2 1
6/30/12 3:37 PM 2 1
6/30/12 3:38 PM 2 1
6/30/12 3:38 PM 3 1
6/30/12 3:39 PM 2 1
6/30/12 3:39 PM 2 1
6/30/12 3:39 PM 2 1
6/30/12 3:39 PM 4 1
6/30/12 3:39 PM 2 1
6/30/12 3:39 PM 2 1
6/30/12 3:39 PM 6 1
6/30/12 3:40 PM 2 1
6/30/12 3:40 PM 2 1
6/30/12 3:41 PM 2 1
6/30/12 3:41 PM 2 1
6/30/12 3:41 PM 2 1
6/30/12 3:41 PM 2 1
6/30/12 3:41 PM 3 1
6/30/12 3:41 PM 2 1
6/30/12 3:42 PM 5 1
6/30/12 3:42 PM 2 1
6/30/12 3:42 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:43 PM 2 1
6/30/12 3:44 PM 2 1
6/30/12 3:44 PM 2 1
6/30/12 3:44 PM 2 1
6/30/12 3:45 PM 5 1
6/30/12 3:45 PM 2 1
6/30/12 3:45 PM 2 1
6/30/12 3:46 PM 2 1
6/30/12 3:46 PM 2 1
6/30/12 3:46 PM 2 1
6/30/12 3:46 PM 2 1
6/30/12 3:46 PM 2 1
6/30/12 3:46 PM 2 1
6/30/12 3:47 PM 2 1
6/30/12 3:47 PM 2 1
6/30/12 3:47 PM 2 1
6/30/12 3:47 PM 2 1
6/30/12 3:47 PM 2 1
6/30/12 3:47 PM 5 1
6/30/12 3:48 PM 5 1
6/30/12 3:48 PM 4 1
6/30/12 3:48 PM 5 1
6/30/12 3:49 PM 4 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 5 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 2 1
6/30/12 3:49 PM 2 1
6/30/12 3:50 PM 2 1
6/30/12 3:50 PM 2 1
6/30/12 3:50 PM 2 1
6/30/12 3:50 PM 2 1
6/30/12 3:50 PM 4 1
6/30/12 3:50 PM 2 1
6/30/12 3:50 PM 2 1
6/30/12 3:50 PM 2 1
6/30/12 3:51 PM 2 1
6/30/12 3:51 PM 2 1
6/30/12 3:51 PM 2 1
6/30/12 3:52 PM 2 1
6/30/12 3:52 PM 2 1
6/30/12 3:52 PM 2 1
6/30/12 3:52 PM 2 1
6/30/12 3:52 PM 3 1
6/30/12 3:52 PM 2 1
6/30/12 3:52 PM 2 1
6/30/12 3:53 PM 2 1
6/30/12 3:53 PM 2 1
6/30/12 3:53 PM 2 1
6/30/12 3:53 PM 2 1
6/30/12 3:54 PM 2 1
6/30/12 3:54 PM 2 1
6/30/12 3:54 PM 2 1
6/30/12 3:54 PM 2 1
6/30/12 3:55 PM 2 1
6/30/12 3:55 PM 2 1
6/30/12 3:56 PM 2 1
6/30/12 3:56 PM 2 1
6/30/12 3:56 PM 2 1
6/30/12 3:56 PM 2 1
6/30/12 3:56 PM 3 1
6/30/12 3:57 PM 5 1
6/30/12 3:57 PM 2 1
6/30/12 3:58 PM 2 1
6/30/12 3:58 PM 2 1
6/30/12 3:58 PM 2 1
6/30/12 3:58 PM 2 1
6/30/12 3:58 PM 2 1
6/30/12 3:58 PM 2 1
6/30/12 3:58 PM 3 1
6/30/12 3:58 PM 2 1
6/30/12 3:59 PM 2 1
6/30/12 3:59 PM 2 1
6/30/12 3:59 PM 2 1
6/30/12 3:59 PM 3 1
6/30/12 4:00 PM 2 1
6/30/12 4:00 PM 2 1
6/30/12 4:00 PM 2 1
6/30/12 4:01 PM 2 1
6/30/12 4:01 PM 2 1
I have this kind of data.
I want data in report as givn below:
I have this kind of data.
I want data in report as givn below:
Time Span Transection types
1 2 3 4
__________________________________________
00:00:00 to 00:15:00 5 3 1 2
00:15:00 to 00:30:00 4 5 4 7
00:30:00 to 00:45:00 7 1 3 2
00:45:00 to 01:00:00 4 3 2 1
00:10:00 to 01:15:00 1 2 4 5
这篇关于数据处理所需的SQL SP。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文