Multiple Queries In-Database

robertfishel

Almost Friday, Alteryx Community.  Can. You. Feel. IT!?!?!?!?!?!?!?!?

So i am just starting to get into the In-Database tools.  I have a SSMS query that is really two queries, one being a query that creates a temp table, which is then itself queried.  Confused yet.

So in Alteryx, I have successfully used the Connect In-DB tool to bring back the desired results of the first part of  my query (the temp table part).  Now, I am wondering how I would run the second part, which queries the temp table?  Is it one of the In-Database tools, or am I going about doing this the wrong way?  Can you create a temp table using the In-Database tools, just like you would in SSMS?  Thanks. 

Claje

Hi!

Let me try and help out:

Take the SELECT query that you are using to run the first query, and put it in a "Connect In-DB" tool.

If your second query only uses results from the first which creates a temp table, try using the Filter, Formula, Select, and Summarize In-DB tools to recreate that query.

If your second query JOINS to your temp table, take the piece of query 2 which selects fields from tables that are NOT your temp table, and put that in a second "Connect In-DB" tool.  Then, use a "Join In-DB" tool followed by a "Select In-DB" (and possibly a "Filter In-DB") tool to perform the Join you are using in your current SQL.