This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
SELECT a.name FROM
(SELECT name FROM agentinformation) a
In a regular Input Data tool and Alteryx will handle it fine. I have sometimes found that Alteryx has a hard time with these types of queries in the In-Database tools (since from a technical perspective, the In-Database tools create very similar subqueries, so they don't always nest appropriately).
With regards to write permissions needed for temp tables - I'm not an expert on SQL Server or any other database technology, but my understanding is that typically the ability to create temp tables and the ability to write to a permanent table are two separated permissions, so it is possible to have access to use In-Database without having permission to create a New Table.