how to insert into a table where you dont know the amount of values that can be stored code example

Example: Having trouble running COUNT in my INSERT INTO statement

ROW_NUMBER() OVER(ORDER BY tblPlayers.PlayerID) AS TransactionID