Parallel INSERT

You can give a try on OUTPUT clause with Insert query,

INSERT INTO test (info,userid)
OUTPUT INSERTED.ID ---whatever the test table column name is
 VALUES (@request_info,@request_user_id);

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

thanks a lot for this alternative on how to obtain the inserted ID; however, the above problem is still unsolved.