Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pim1965
Starting Member
1 Post |
 Posted - 2006-01-26 : 18:59:54
|
| I need a complete sql sript for selecting each day a variable stored datetime field arround 6:00 pm (should be something between m/d/y 5:59pm and m/d/y 6:01 pm. (data is stored every two minutes) The daytime field is the index.Next I need the last 30 stored days from today every day again. With the above value from another field.Later I need to draw from this results a linegraph on my website.Pim |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-01-26 : 19:36:44
|
quote:
Originally posted by Pim1965
I need a complete sql sript for selecting each day a variable stored datetime field arround 6:00 pm (should be something between m/d/y 5:59pm and m/d/y 6:01 pm. (data is stored every two minutes) The daytime field is the index.Next I need the last 30 stored days from today every day again. With the above value from another field.Later I need to draw from this results a linegraph on my website.Pim
That sounds great! Thanks for letting us know, and good luck! If you have any questions, feel free to ask. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Complex (for me) selection for line chart in asp