Jeff Moden (1/5/2016)

---

Careful now... Does it? With...

Thanks for all of the responses.

I've gone with the first solution from Eirikur as it did exactly what was required :-).

Apologies that I keep posting but I have just amended part of the ISNULL section to DATEADD(DD,DATEDIFF(DD,0,GETDATE()),3650))

and this now allows me to extend the working pattern forwards, as I am...

I am having a slight problem, the solution works perfectly for records in the past but will only display a working pattern up to the current date.

For example if I...

This does exactly what I need thank you. I appreciate you taking the time to not only provide a solution but to also explain what it is doing.

I am going...

capnhector (11/14/2012)

---

i have a question about #Working_Pattern. This table holds the days of the week an employee works with the start date being the date the new schedule became...

Check the database compatibility level. Can be found in the GUI by right clicking on the database > properties.