SQL

SQL Server Splitting a string column into multiple rows, while repeating ID column

INSERT INTO TempSubProduct (ID, SubName)
SELECT ProductID, SPL.value
FROM Production.Product  AS PP
CROSS APPLY STRING_SPLIT(PP.Name,' ') AS SPL;