Find the 1st value to cross a specific threshold value

• JazLady

  Old Hand

  Points: 358

  More actions

  December 19, 2013 at 8:35 am

  #280467

  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.

• KS

  Hall of Fame

  Points: 3323

  More actions

  December 19, 2013 at 9:40 am

  #1674908

  Please do not cross post. Original thread can be accessed here

  http://www.sqlservercentral.com/Forums/Topic1524645-3077-1.aspx