I created a Talend MS Sql job using tMSQLInput_1 and inserted my own query. Below is an 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 accounted 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 account. Have anyone seen this issue with Talend before and if so how do I fix it.