alternative method for placing the record count from a table into a variable

DECLARE @sql nvarchar(100),@Reccount int

SET @sql = 'SELECT COUNT(*) FROM InterchangeDTA.dbo.' + @TableName

EXECUTE sp_executesql @sql, N'@Reccount int output', @Reccount output

Then you can insert

INSERT INTO TableCounter (TableName) VALUES @Reccount

btw, you state TableName as the column for insert but use the count as data! Is this right?