Thanks for weighing in. My concern is just that if I create a "master" record in "people" and use their "real name" in that table, what's to prevent that name...

Sorry, I would like to help, but there are just too many things about all of this that don't make sense to me.

For example, why are you (seemingly) storing...

Sorry, that one issue was a typo on my part, meant to write "column" instead of "row" for days. I have edited that post.

The "1-24" was just an example...

Hmm, okay, thanks for the reply. I think I'm following you, and it sounds like you're basically suggesting that I proceed with my "separate AKA's table" idea, except that it...

I'm just some guy, but it seems that the answer depends on the specifics of your situation.

A week will always have the same 7 days in it. That's not...

Jonathan's code (above) made sense to me. But I couldn't really figure out what was going on in...

Craig, do you think this set of SSMS tools would be appropriate? It claims to be able to autogenerate the CRUD wrappers you suggested. Seems like it will be important...

I love you guys. Thanks!

I loved "Microsoft SQL Server 2008 T-SQL Fundamentals" and "Pro SQL Server 2008 Relational Database Design And Implementation".

THANK YOU!

Okay, thanks for the answer. I think I was basically on the right track, that the whole "Grouping" thing is just a convenient way to check for NULL intersections. And...

AWESOME! I love this article. Solid, logical, intelligent.

I'm the first to admit that I'm naive and uninformed, but it sounds to me as if it's basically an issue of you:

1) deciding what data you need to store,...

Could you just use change data capture, or any traditional type of trigger-based auditing to...

Nice, and thanks for giving me an inferiority complex about my signature now... 🙂 Seriously, though, you guys are the best. I'll refrain from offering forum advice for awhile, but...