This is endless conversation. Let me say that I am teaching classes "relational database design". So I know and advocate relational theory as much as I can. And I am...

Completely agreed with you that from time to  time MUCK design is the better design even it is against the relational rules.

Very pathetic. But I am wondering how people are reading the article and do they really understand what theory and practice mean and the differences between pure theory and...

Thanks for the comment. I will try to write another article and place more info

Yes, you right, solution has some limitations and as I pointed it has a probability to get a wrong result. But in many cases this probability is small.

Thank you. It is always intresting to get new and additional ideas from the professionals

Thanks, it is a good idea to automate even more and add email option as additional step

Leo Peysakhovich

Thanks , your comment is true.

Thanks for the tip. But the stored procedure you pointed is undocumented. I am trying to use only documented procs to be able to use it between SQL Server versions....

Will do it. It become interesting.

I am in class for 3 days. But then I will make some experiments and let you know. Thanks for the remark. Sorry for the...

I didn't check it. But I will. I was stating based on SQL Server Book on line.

You can use any type of email. Check internet there are bunch of articles how to use CDO mail object. I just didn't focus on mail portion. Sorry.

If you are relational DBMS purist, then you are the purist. I am the guy who is very practical, despite my very high teorethical degree and very high level of math...

The arguments may be endless. But database is primerely is a data storage. In the article, I did outlined different ways to construct lookup tables but it is up to...

First, I am an author of the article. Second, pure scientifically developed relational database is not very often good for the practical use. Third, it is like endless question what...