sql server insert values with same column if don't exist in grouped values query with some same values code example

Example: Having trouble running COUNT in my INSERT INTO statement

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