OK, so there is a table that is basically an audit trail, it is on MS SQL Server 05 and soon to be 08.<BR><BR>AuditTrail<BR>AuditID -- PK<BR>SomeFK -- FK to tie it back to the record<BR>FieldName -- ...

When you insert new records into an SQL database, you may run into issues where you accidentally overwrite records that are already present due to a duplication issue. You can use a simple alteration ...