Hi,

Do u mean u tried it but no success?

Thanks for the quick response ‌. I am having problems with my connection test, getting a login failed. I also an unsure where to reference the stored procedure.

Should be possible. 

Running an SQL procedure (via the "Execute SQL" action) can look like this:

Connection:

Data Source=(whateveritis);Initial Catalog=(catalog);User ID=un;Password=pw;

Procedure:

exec ProcedureNameHere 
@Item1={WorkflowVariable:textHazardID},
@Item2 ={WorkflowVariable:whatever},
@Item3= {ItemProperty:whatever},

You can then store the output (if any) in a collection or single item, depending on what its returning.

Excellent, this is exactly what I needed to get this working. THANK YOU!