how to manage to get the range Id of a specific number of minutes

• DZN61

  SSChasing Mays

  Points: 628

  More actions

  August 30, 2012 at 6:52 am

  #260726

  Hi

  I can imagine that the subject is not clear at all...

  So let's give you an example.

  I have a table with dates (begin, end) and an elapsed time in minutes.

  1 2012-01-01 08:00 21-01-01 10:00 60

  2 2012-06-01 10:12 21-06-01 18:13 481

  etc ....

  I have another table with minutes range

  ID Title Range MinutesRangeBegin MinutesRangeEnd

  1 < 15 min 0 15

  2 >15 min < 30 min 16 30

  3 >31 min < 1h 31 60

  4 >1h < 8h01 61 481

  5 >1day < 2 days 14401 28800

  ....etc......

  I would like this kind of result :

  inital table Range Id (added)

  1 2012-01-01 08:00 21-01-01 10:00 60 3

  2 2012-06-01 10:12 21-06-01 18:13 481 4

  How achieved this with a select statement ?

• cporteous

  SSC Eights!

  Points: 996

  More actions

  August 30, 2012 at 6:58 am

  #1531850

  Hey,

  Without typing it out for you, have a look at this example. Same idea as what you need.

  Thanks

  http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/36f70eed-68c7-4d0e-8967-aa366780c8b2

• DZN61

  SSChasing Mays

  Points: 628

  More actions

  August 30, 2012 at 7:10 am

  #1531857

  Tks for quick reaction. I will have a look on it!