I now need to turn this into a insert statement, calls_key a the primary key and i'm getting a new error on that issue. Can you help on that?

Thank you

SET IDENTITY_INSERT CALLSNEW ON

--INSERT INTO [CALLSNEW]

INSERT INTO [cas].[dbo].[CALLSNEW]

SELECT

calls_key = oq.calls_key,

ext = oq.ext,

calltype = oq.calltype,

dept = e.dept,

fname = e.fname,

lname = e.lname,

empnum = e.empnum

FROM

[EMP] e

inner join OPENQUERY(PHONEDB,'SELECT calls_key, ext, calltype FROM calls') oq

on (e.ext = oq.ext)

WHERE

e.ext = oq.ext

AND e.active = 1

and oq.calltype IN ( 'from-internal', 'ext-local', 'ext-queues', 'ext-group')