I created a Talend MS Sql job using tMSQLInput_1 and inserted my own query. Below is example of my query.
if object_id('tempdb..#lang_guid')is not null
drop table #lang_guid;
create table #lang_guid(
patient_guid varchar(255)
,accountid varchar(255)
);
insert into #lang_guid
select c.customerid
,'0000001'
from customer c with(nolock)
select patient_guid
,accountid
from #lang_guid
The issue I'm having is the query pulls the patient_guid from the table but not the accountid I creating that on the fly in the temp table. when i run the job in Talend it returns the patient_guid but I don't get any data back for the accountid. Have anyone seen this issue with Talend before and if so how do I fix it.
