Home Forums SQL Server 2008 SQL Server 2008 - General How to Consume Return Values From Table Valued Function RE: How to Consume Return Values From Table Valued Function

  • July 9, 2014 at 6:23 am

    #1728008

    bill.warner7 (7/9/2014)

    How do I do an insert for each row, without iterating over the available rows?

    if runtime temp table is ok then you can use below:

    SELECT * INTO #tempTable FROM dbo.MyFunction(param, param)

    If table is already present with same return values (columns) then you can use:

    INSERT INTO TABLE (column1) SELECT column1 FROM dbo.MyFunction(param, param)

    Thanks