What about something like this?

DECLARE @sp-2 nvarchar(max)
DECLARE @RunID INT
SET @RunID = (SELECT MAX(RunID) as RunID FROM [RISE].[dbo].[tb_CompaniesToRun])

-----------------------------------------------------------------------------------------------
------------------- EXECUTE ALL THE STORED...

Some small improvements to Thomas' code. Even with dynamic code, I like to keep it with a good format to ease the debugging.
I'm also using sp_executesql which would allow...

What about something like this to avoid creating more rows?

CREATE TABLE ProductDiscounts (
Stack VARCHAR (255),
ProductCode VARCHAR (255),
ValidFrom DATE,
ValidTo DATE,
Discount1 decimal(4,3));

Maybe something like this:

WITH CTE AS(
  SELECT *,
   MIN(CASE WHEN TestResult = N'Fail' THEN CycleID END) OVER(PARTITION BY MemberID) FirstFail
  FROM...