Thanks very much this is exactly what I was after, I was away trying to write a cursor and it was melting my head.

Is there any simple way...

Almost what I'm after, unfortunately I need the 'To' and 'From' dates that the location would be valid. Think the best option might be to write it into another table...

Length is always in minutes, thanks for the input folks very much appreciated. Will try the advice above.

Apologies if I was unclear, we have a master schedule table which tells us the start time and end time of the overall schedule and the length of a session...

Agree in this scenario it's for a BI application and I doubt it can handle self joins, throw in the fact it's been dimensionally modelled and it adds it a...

Thanks for the advice, I was hoping to store it to avoid the computations being done by an application. I like to have as much stored as possible via ETL...

I'd like to be able to write a cursor of similar code which does this dynamically for me based on a data set that I have. So I can store...

Exactly like that Chris, yes.

I would like if possible to have it stored on the table, I may be able to push it onto the app but would be dependant on the query.

Hi Chris,

I've ammended my code sample to hopefully clear up the date logic. In regards to the other questions I'm happy to leave the comparison column null where it doesn't...

Hi Sean, aplogies for the lack of standardisation I have updated my code sample in accordance with your post(hopefully)

Thanks for the responses delving into the unknown 🙂

Struggling though to understand why a vanilla install of the server which I've done countless times would perform so poorly other than...

Thanks Gail currently working my way through this.

Recurs1on (2/6/2012)

---

Without knowing a lot more about how your system is configured, it would be very difficult to make suggestions. For example:

- What RAID levels are you using and how...

Recurs1on (2/6/2012)

---

Without knowing a lot more about how your system is configured, it would be very difficult to make suggestions. For example:

- What RAID levels are you using and how...