In theory, the compiler is allowed to rearrange the joins as long as it effectively...

This is totally off-topic. My experience in Mensa was incredibly positive. The Atlanta chapter (I was actually president for one term) was fun, enjoyable and productive. One group of members...

>> it would be great if someone could help me with the following problem. <<

Where is the DDL? Did you read the basic netiquette of this forum or...

>> I have an order by statement like so: <<

ORDER BY is a clause...

>> Btw, the US fed govt already announced, some time back, that it intends to move away from DUNS numbers to a more open system. Best of luck to all...

>> Cc nums are not typical anyway, they'd almost certainly end up stored as varbinary because of the compression method(s) used on them. <<

I thought the credit cards...

I think we need to back up and get some terminology corrected here. We say that we have a concatenation, it's a string with an ordering and there doesn't have...

You're trying to normalize your schema. The heuristic is to first look for entities. You have two of them based on your data; personnel (not employees! Use a collective noun...