sql temp tables in tmssqlinput

[Anonymous]

I am running a query on a mssql db. The query runs perfectly fine in microsoft sql server management studio. However, the query will not run in talend. I cannot share the code but below is the general flow of the code. 

BEGIN

DECLARE A FEW VARIABLES

SELECT INTO TEMP TABLE1

SELECT INTO TEMP TABLE2

run queries

drop temp tables 

Could someone please demonstrate the proper way to do this sort of query in talend?

[vapukov]

---

@Robert_gill wrote:

I am running a query on a mssql db. The query runs perfectly fine in microsoft sql server management studio. However, the query will not run in talend. I cannot share the code but below is the general flow of the code. 

BEGIN

DECLARE A FEW VARIABLES

SELECT INTO TEMP TABLE1

SELECT INTO TEMP TABLE2

run queries

drop temp tables 

Could someone please demonstrate the proper way to do this sort of query in talend?

---

"BEGIN
          DECLARE A FEW VARIABLES;
 
          SELECT INTO TEMP TABLE1;
          SELECT INTO TEMP TABLE2;
 
          run queries;
 
          drop temp tables ;

END"

[Anonymous]

That is how I had my code initially. If I use ";" talend throws syntax errors and if I don't use ";" the query begins to run then stops without displaying any sort of message. 

[vapukov]

look,

I can try to guess - what are do wrong ... but do I need this?

what I know, my code - is work

I have my own code - it work

I create code similar to describe in Your pseudo code - it work

why all must guess - what also You are forget include 🙂

Code:

Result:

[Anonymous]

It is weird, the query results do not appear when i test the query.
However, talend can guess the schema and pull the data

[vapukov]

tSQLRow - do not proper component for return result (even in combination with)
Use tMSSQLInput instead