MSSQL Stored procedure

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 image
so that it is readable thanks.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.