TryingToLearn (12/29/2012)

---

i am querying a MySql view for data, but need to join to a sql table for three additional fields.

SET IDENTITY_INSERT CALLSNEW ON
INSERT INTO [cas].[dbo].[CALLSNEW]
([calls_key]
,[ext])

SELECT * FROM OPENQUERY(PHONEDB,'SELECT calls_key, ext FROM calls')
Where calltype IN ( 'from-internal', 'ext-local', 'ext-queues', 'ext-grou')


but i need to join to a linked SQL server as well to get a few more fields. I could use suggestions on how to do that.

SELECT dept = dbo.EMP.dept, fname = dbo.EMP.fname, lname = dbo.EMP.lname, empnum = dbo.EMP.empnum
FROM linkedserver.dbo.EMP
WHERE dbo.EMP.ext = ext
AND dbo.EMP.active = 1



thanks for your time.

TryingToLearn (12/29/2012)

---

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')