Yak Posting Veteran
Posted - 11/12/2013 : 01:56:52
| Guys I am developing a job that will copy data from MySQl to MSSQL, I have a few of them that are working well, but this one has me stumped as its not finding any data, yet when I query the table there is new data there when I refer to the dates there is a few hundred rows.
here is what the query looks like:
insert into [tempTest]
select * from openquery([support_cases],
o.creation_date as comm_creation,
o.last_updated_date as comm_last_updated,
FROM o_communications o
join o_case_communications as cc on o.COMM_ID=cc.COMM_ID
left join d_case_details cd on cc.case_id=cd.case_id
where comm_date_utc >= DATE_SUB(CURRENT_DATE(), INTERVAL 15 DAY)
and is_Customer_sender = ''Y''
and (cd.email_queue_name like ''support%'' or cd.email_queue_name like ''acme%'')
and cd.email_queue_name not like ''%-cs%''
and cd.email_queue_name not like ''%test%''
and cd.email_queue_name not like ''%trms%''
where not exists (select 1
where comm_id = t.o.comm_id
I have tried cutting out many of the and clauses, but this is not the problem, as they seem to fit the bill when manually going through the data.
Any clues as to what this could be?
Edited by - 2revup on 11/12/2013 01:57:34