I would like a sproc to work against two tables...<BR><BR>Table1 has an ID field (auto increment/PK) and a varchar(256) field.<BR>Table2 has an ID field (each entry should match an entry of the ID ...
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 -- ...