Chris,

>So, what your saying is count the number of records prior to the insert, then count them after?

@@ROWCOUNT tells you how many rows were affected by the previous statement.