Try this bit in the middle:

SELECT @contact_id = contact_id,

@staff_issued = staff_issued

FROM inserted

The inserted "table" contains the record you have inserted whilst contacts won't know which record you want.