Prev: Highest and lowest values
Next: Change Service Account Password
From: sameer on 7 Jul 2008 07:31
Hi,

MY input values

Low Value:

A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be
HIGH.

High Value:

A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be
LOW.


create table temp(time datetime,[close] money)



insert into temp values('11:20','4006.00')

insert into temp values('11:21','4007.20')

insert into temp values('11:22','4008.00')

insert into temp values('11:23','4009.70')

insert into temp values('11:24','4010.00')

insert into temp values('11:25','4011.50')

insert into temp values('11:26','4012.80')

insert into temp values('11:27','4013.00')

insert into temp values('11:28','4012.00')

insert into temp values('11:29','4011.90')

insert into temp values('11:30','4012.80')

insert into temp values('11:31','4013.60')

insert into temp values('11:32','4014.20')

insert into temp values('11:33','4013.00')

insert into temp values('11:34','4012.40')

insert into temp values('11:35','4014.20')

insert into temp values('11:36','4015.60')

insert into temp values('11:37','4017.40')

insert into temp values('11:38','4018.50')

insert into temp values('11:39','4019.00')

insert into temp values('11:40','4020.50')----------high--

insert into temp values('11:41','4018.00')

insert into temp values('11:42','4017.70')

insert into temp values('11:43','4016.80')

insert into temp values('11:44','4017.50')

insert into temp values('11:45','4018.40')

insert into temp values('11:46','4016.00')

insert into temp values('11:47','4015.60')

insert into temp values('11:48','4014.00')

insert into temp values('11:49','4013.30')

insert into temp values('11:50','4012.60')

insert into temp values('11:51','4011.40')

insert into temp values('11:52','4010.19')------low---

insert into temp values('11:53','4011.60')

insert into temp values('11:54','4013.50')

insert into temp values('11:55','4014.40')

insert into temp values('11:56','4015.00')

insert into temp values('11:57','4017.80')

insert into temp values('11:58','4018.00')

insert into temp values('11:59','4019.40')

insert into temp values('12:00','4018.10')

insert into temp values('12:01','4017.30')

insert into temp values('12:02','4019.00')

insert into temp values('12:03','4021.50')

insert into temp values('12:04','4025.00')

insert into temp values('12:05','4027.70')

insert into temp values('12:06','4029.80')

insert into temp values('12:07','4031.00')

insert into temp values('12:08','4032.20')

insert into temp values('12:09','4033.00')----high---

insert into temp values('12:10','4032.00')

insert into temp values('12:11','4031.00')

insert into temp values('12:12','4030.00')

insert into temp values('12:13','4030.50')

insert into temp values('12:14','4031.80')

insert into temp values('12:15','4032.00')

insert into temp values('12:16','4031.00')

insert into temp values('12:17','4029.00')

insert into temp values('12:18','4027.00')

insert into temp values('12:19','4025.00')

insert into temp values('12:20','4024.00')

insert into temp values('12:21','4022.00')----low---

insert into temp values('12:22','4023.00')

insert into temp values('12:23','4024.80')

insert into temp values('12:24','4024.10')

insert into temp values('12:25','4023.50')

insert into temp values('12:26','4022.00')

insert into temp values('12:27','4023.00')

insert into temp values('12:28','4024.50')

insert into temp values('12:29','4025.00')

insert into temp values('12:30','4027.00')

insert into temp values('12:31','4028.00')

insert into temp values('12:32','4029.00')

insert into temp values('12:33','4031.00')

insert into temp values('12:34','4033.00')

insert into temp values('12:35','4035.00')

insert into temp values('12:36','4037.00')

insert into temp values('12:37','4039.00')

insert into temp values('12:38','4042.00')









out put table looks like:



11:40 4020.50

11:52 4010.19

12:09 4033.00

12:21 4022.00

 | 
Pages: 1
Prev: Highest and lowest values
Next: Change Service Account Password