Here is what I came up with to return a list of all inserted ID's:
USE [Research]
GO
/****** Object: StoredProcedure [WEB].[sp_GetCasesFromPowerPath] Script Date: 1/31/2022 3:09:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE...