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.
Running stored procedures in Alteryx using either an Input Data or Dynamic Input is awesome, however there is one quirk. Each of these tools is actually expecting there to be some data returned, so even if the sproc isn't supposed to return anything, you still need to add a dummy SELECT statement at the end of the stored procedure script.
I've used this method in the past with a sproc that deleted specific records, so I had no intention on returning anything. I ended up dumping the deleted records to a temporary table, then selecting the record IDs from that table at the end of the sproc so Alteryx would actually return something and not give that error. In the end, it actually worked to my benefit as I could then keep track of records that were automatically being deleted.