Hi All,

When recursive  data extracts are required, try CTE:

DECLARE @SPLITROW TABLE
(ORDER_NUMBER INT
, PRODUCT_ID INT
, QTY INT
, VALUE MONEY
)