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

how to manage to get the range Id of a specific number of minutes Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 6:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, August 30, 2012 6:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 7:49 AM
Points: 92, Visits: 104
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
Post #1352171
Posted Thursday, August 30, 2012 7:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 19, 2012 4:05 AM
Points: 24, Visits: 60
Tks for quick reaction. I will have a look on it!
Post #1352181
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse