I have one table that I'm inserting multiple records that are comming from 3 different functions.
INSERT INTO tb_ing (ing_reci, ing_desc, ing_amt, ing_unit) select @scope, dbo.udf_split(@ing_desc,'|'), dbo.udf_split(@ing_amt,'|'), dbo.udf_split(@ing_unit,'|')
NOTE: @Scope is an identity value that is supposed to repeat for all row values.
dbo.udf_split is a function. That returns a one column table of values with the col name of "Items". EACH FUNCTION RETURNS THE SAME NUMBER OF ROWS.