Generate Demo Data in SQL Server

WITH RecipeRandom AS(
SELECT
     Invoices.ID Invoices_ID
    ,CAST(RAND(CHECKSUM(NEWID())) * 8 as INT) + 1 Recipe_ID
FROM Invoices
)
INSERT INTO invoices_det(ID_INVOICE, RECIPE_NAME, PRICE)
SELECT
     Invoices_ID
    ,NAME
    ,PRICE
FROM RecipeRandom
LEFT JOIN Recipes ON RecipeRandom.Recipe_ID = Recipes.ID
;