Ah, I was researching elemenTARTY keys, probably why I got it wrong 😉

since switching to contracting 3 years ago, I've found fitting in and becoming part of the team much quicker and easier to do. on average, it'll take me around...

Good question, great answer 🙂

Thanks,

Tom

Thanks, Jeff. Also some interesting stuff about control characters, something I've never really considered before.

Tom

My thoughts exactly

Argh, got this one wrong (I knew it as I clicked the button).

Managed to work out what the second field was for and then rushed my answer for the first...

arghh!! I spent a few minutes playing with a spreadsheet to mock up the bitwise AND and OR functions (a happy little diversion) and i missed the data type gotcha!

ah...

Warren Gilbert (10/1/2009)

---

I am also of the opinion that the answer is incorrect.

The question specifically asks for extensions (subclauses) to the GROUP BY clause.

GROUPING_ID is a function, NOT a sub-clause...

if you use SSMS, you can right-click on the table and choose properties. Within the properties window there is a section for storage which has an entry for the...

have worked out how to implement this using a hierarchy bridge and multiple hierarchies. see the section on multiple hierarchies in this pdf document for more information.

happy to discuss...

Ideas/things I have tried: