Ars Technica

TSQL - inserting ~20 records into a table using a sproc: most efficient way?

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 -- ...