These are all great books.

http://www.amazon.co.uk/Microsoft-Server-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=pd_sim_b_7

http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2008/dp/0735626030/ref=pd_sim_b_3

http://www.amazon.co.uk/Inside-Microsoft-Server-2008-Pro-Developer/dp/0735626022/ref=pd_sim_b_3

Don't mind the UK links, these should be available just about everywhere

Thanks Hyung-Joo, very helpful information.

Great article Bob. It couldn't have been easy to find examples that lined up so nicely to demonstrate your point. I'm guessing there are quite a few hours...

Among several other things.

Honestly, it's one of the things that is 'cool', but I haven't figured out what a practical need would be for it yet. Here's the query...

I'd agree with that completely. Had some fun playing with "GROUPING SETS" this morning myself...

My pleasure, and same to you.

Yep, delete and not replace it with anything. I assumed this would be on an entity per entity basis, but if you don't care about the entities and only...

My turn for an oops. For whatever reason, when I was reading this last night it appeared that the %'s were all off based on the numbers and made...

How hard would it be to break these steps into agent job steps? I could be completely off base here, but usually when I see problems like this it is...

The amount of data (both starting and the amount of data you need for your 'result' post processing) is a big factor here, but there's also the concept of doing...

What triggers this procedure/process? Does it need to be run on user demand or can it be done as a periodic scheduled job?

Wasn't trying to be picky, if cross joins weren't also a real thing I wouldn't have said a word... I just know that my memory plays tricks on me sometimes...

Debbie Edwards (3/5/2010)

---

Thanks all.

I have just used the query in my original SP instead of the ridiculously long one and it works a treat.

I hope at some point I will...

Something to keep in mind when using NOT IN:

http://www.sqlservercentral.com/blogs/never_say_never/archive/2010/01/28/in-and-not-in.aspx

I went ahead and debugged this, you can run the whole statement. Note a few things.

1. Your sample data doesn't match your results, things like the workingdayofmonth doesn't...