Hey guys,
how to execute a stored procedure and store the result to use in another query?
Welkom to the forum
Search INSERT the data into the database, there is a node for MYSQL aswell
Welcome @egoncalves
This thread about how to execute a stored procedure in MSSQL should help. Obviously your inputs & outputs are different, but this should get you going.
Thanks for your attention, I don't think I was able to express myself properly, I would like to run this example query, and get a return value from the entire execution like this example.
declare @ReturnID int
execute @ReturnID = [dbo].[LogN2_Event] 1,1 ,1
print 'Return value = ' + cast (@ReturnID as varchar (10) )
Return value = 1053658
Completion time: 2021-11-10T16:30:07.1955275-03:00
After the procedure runs, it returns a value that I store in the @ReturnID variable
Please wrap your code in code tags
so that it is readable thanks.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.