It seems the question is slightly ambiguous due to a confusion over whether a PK is a theoretical construct or a database element.

If we look at the PK as a...

It seems to me that, while misrepresentation is a problem, the real issue is benchmarks and payment.

When I do consulting I much prefer to bill by the job/milestone instead of...

Pretty much anything you can do in Access VBA you can do with an ActiveX script task. You can use VBScript for an ActiveX script so the conversion isn't...

As others have said. Don't do this. If you think about it, creating a completely generic procedure to insert into the database is exactly the same as just...

Steve,

I think that data quality/precision is at least as important as data quantity. Especially in scenarios like weather prediction and terrorist determination. At some point, more data isn't...

Ryan,

I agree, but I forgot one comment, you said earlier:

Good discussion. I never expected...

If the first seller does not maximize their profits, and someone else comes along to buy the good at the lower price to sell at a higher price (and people...

I'm also a member of my community association and we deal with this issue. It would be much faster and cheaper to send emails vice printing a newsletter, but many...

But first come / first serve is a capitalistic option. While it doesn't necessarily maximize profits for the World Series events, it may lead to increased season ticket sales for...

This seems to indicate that you think first come/first serve is not a fair method. I would disagree. This method is very capitalistic, as is the ability for someone to...

> How can we provide fair access to digital goods?

I have a problem with "fair" in most instances because it is usually just a way of whining.

However, in the example...

Try...

It solved your problem, but I don't think it does what you want it to do. Your trigger is affecting EVERY ROW of the table regardless of which rows...

Isn't the traditional solution to create Stored Procedures to update the base tables and give the user permissions to the SPs.

JimFive

I didn't notice this originally but as ColDist is a float (consider Decimal/Number) it is possible that the above loop could become an infinite loop due to rounding issues.

Also, you're...