Knowledge Base Article

SELECT Like a Boss With Query Parameters

SQL : cross and delight of the IT revolution. If you've been in the game for more than a few years, chances are that you got your hands dirty with database queries once or thrice. OneStream itself...
Updated 2 years ago
Version 4.0
rules
ChrisR1ch's avatar
ChrisR1ch
New Contributor III
1 year ago

Sergey 

I'm referring to an output parameter of the DB Stored procedure.

So in the example above you are only sending parameters into the stored procedure, but stored procedures can return parameters back out.  How can I pull the OUTPUT parameter and use it in my business rule?

Dim SqlQuery As String = "EXEC SP_API_CLIMATIQ_TRAVEL_FLIGHT @param1_IN=param1Val,  @param2_IN=param2Val, @param3_OUT"