Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find the 1st value to cross a specific threshold value Expand / Collapse
Author
Message
Posted Thursday, December 19, 2013 8:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 3, 2014 9:33 AM
Points: 10, Visits: 79
I need a query to get the first value greater than a specific threshold value

LoadTemp1 LoadTemp2 LoadTemp3 LoadTemp4 TimeStamp
300 200 100 320 12-10-2013 13:30:29
100 250 113 340 12-10-2013 14:20:12
114 339 209 345 12-10-2013 14:45:01


I need to get the first value >= 340 threshold

I need to make a Benchmark on when the first LoadTemp crosses Threshold of 340 and capture the time.

Please help.
Post #1524629
Posted Thursday, December 19, 2013 9:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 1,073, Visits: 857
Please do not cross post. Original thread can be accessed here

http://www.sqlservercentral.com/Forums/Topic1524645-3077-1.aspx
Post #1524688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse