SQL INSERT SELECT Error

With the statment below--I get a error message:

INSERT INTO [SPIResConv5].[dbo].[Transactions]
           ([TRXNO],
            [RESORT_ID]
           ,[TRANSTYPE_ID]
           ,[BILLCODE_ID]
           ,[MAINTENANCE_ID]
           ,[CONTACT_ID]
           ,[POSTED]
           ,[DATE]
           ,[USER_ID]
           ,[BATCH]
           ,[TYPE]
           ,[AMOUNT]
           ,[PAYMENTCODE_ID]
           ,[BANKCODE_ID]
           ,[DOCNO]
           ,[Shift4Trx]
           )
Select
  c.cnt + row_number() over (partition by t.resort_id order by t.resort_id, t.contact_id) as trxno,
       t.Resort_ID,
       TRANSTYPE_ID,      
       BILLCODE_ID,
       MAINTENANCE_ID,
       Contact_ID,
       Posted,
       Date,
       [USER_ID],
       BATCH,
       [Type],
       Amount,
       PAYMENTCODE_ID,
       BANKCODE_ID,
       DOCNO,
       [Shift4Trx]
from   TransactionsTemp t
  left join
  (select Resort_ID, count(*) as cnt from TransactionsTemp group by Resort_ID) c
  on t.Resort_ID = c.Resort_ID


Error Message:

Violation of PRIMARY KEY constraint 'PK_Transactions'. Cannot insert duplicate key in object 'dbo.Transactions'.
The statement has been terminated.


I'm trying to insert into table Transaction,
That has to Primary keys:
[TRXNO], [RESORT_ID]

The TRXNO is the first column in the table--but it has a wierd setup.  
For example

TRXNO  RESORT_ID
3                  ELL2
2                  FAC
3                  CSI
3                  ATR
4                  CSI
3                  FAC
4                  ELL2

It Creates a transaction code- based on the last resort it -transaction -instead just adding a number for the next transaction.

Thanks JKStart Free Trial