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.
If I understand correctly you want to run two SELECT statements and then include the results of these in an EXEC statement that invokes a stored procedure.
To run the SELECT statements you simply need to configure two Input tools. Your second select statement doesn't actually reference a table and you are simply using SQL to work out the last day of the prior month. You can find simpler ways to do this using a Formula tool (the DateTime functions are well documented). So that leaves you with only one Input tool.
To invoke the stored procedure use a Dynamic Input tool. Again, this is well documented and you should be able to modify your SQL statement to include the values from the previous steps of the workflow.
Your final workflow will look something like this:
An Input tool
A Formula tool
A Dynamic Input tool
Since you're connecting to databases there's no way I can replicate this for you, but you will learn the most by doing this for yourself anyway. Please feel free to post up if you have questions as you build the workflow.
The thing is three values for the stored procedure are ffrom sql queries but remainig values are static. If i insert from formula toll it created those many records as my first query and table. PFA screenshot.
Also I am not understandinf, even though I am doing update sP for each column its giving me error opening procedure. Hw can I connect to SP n dynamic tool?
Your method looks OK to me, but you'll need to use unique placeholder values in the template SQL query within the Dynamic Input tool rather than NULL (since all of these will be replaced with the value of the first replacement).