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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » how to manage to get the range Id of a...

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

Rate Topic

Display Mode

Topic Options

Author

Message

DZN61

Posted Thursday, August 30, 2012 6:52 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, December 19, 2012 4:05 AM
Points: 24, Visits: 60

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 ?

Post #1352164