Creating and executing a stored procedure in Alteryx

[tahirlone]

I have an SQL where which has 7 different variables that are to be dynamic in its WHERE and IN clause. 

Some of these variables are start_date, end_date (both have to be in string YYYYMMDD format), source_code, flag_value (Y or N) etc

I am trying to create a stored procedure inside Alteryx to help me run this query eventually using control parameters.

Can I create a stored procedure in Alteryx inside the PreSQL statements of my input tool to help me execute this query?

[apathetichell]

You'd call a stored procedure - but support for this is very odbc driver specific (ie SQL is a language - what DB are you using?). TBH - what you are trying to do can be done a variety of other ways in Alteryx...