Yep, that's fully understood. My point was that the...

That's correct but I like to use it anyway. It prevents me...

We'll typically have a few "canon" branches. Chiefly development and production but we may create ones for specific versions, QA etc. depending on the project. These have continuous...

Apologies, I misread your post and missed the NOT using select:hehe:

In that case I don't know what the difference is but your guess that it's something to do with Code...

EF will only select the columns required by the Linq...

Personally, I would never pimp out my own home to strangers while I'm away. It seems creepy. Also, inviting complete stangers to stay overnight in the guest bedroom in exchange...

I've used it a few times and, on the whole, it's been a great experience, particularly if you're renting a room in someone's house. Most folks who advertise on...

...and they'll always be able to find a table to join

Actually, thanks hugely for that because it gave me something I could actually google for... and guess where it led me[/url]. That's going to take a bit of digesting...

I'll admit that I didn't fully understand that page :ermm: but I believe you are correct. It sounds exactly what I'm after.

If it helps clarify further, I'm fairly convinced I need some sort of recursion here.

E.g. ID 6 associates with IDs 7 and 8. Based purely on that it would...

Hi Sean. Thanks for the response and sorry if I was unclear. Let me see if I can clarify that a bit.

The values in the second column on the...

Thank you. That was exactly the obvious answer I was missing.:-)

Thanks for the info. That link should prove to be a pretty good guide if I need to performance tune some of this later.

Maintainability is the trump card on...

It's a strong driver but not an absolute imperative. I want to keep as much in SSIS as possible...