Thanks. I can try it for myself on Monday when I'm back at the office, but it would have been bugging me all weekend 🙂

I'd have started with a cmd window and

sqlcmd -L

but that's an interesting technique, thanks 🙂

Thanks - some reasons there I had thought of, some I hadn't.

I'll do it the correct way like I was going to, but it didn't hurt to ask - who...

Well I don't even know what BOL is, guessing it's Books OnLine by any chance? 😀

But as with MSDN... I did say I prefer real dead trees for flicking through.

Thanks...

Thanks...

It's the tSQL language rather than the SS application that I'm interested in - so...

Thanks - learning all the time here....

My complete query (2600 rows) takes me 6 seconds with no CTEs - featuring an inline SELECT for one outer join SUM, and a...

Thanks all, I think I've figured out where I went wrong.

I was filtering my C & D results in the main WHERE clause, which obviously affects the total number of...

Thanks, I'm not sure I should post any of this company's code online, so I'll play it safe and not do that.

I was just wondering if I'd overlooked anything that...