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
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.