Home Forums SQL Server 2008 SQL Server Newbies how to store multiple rows in a stored procedure's parameters and then insert them in a table RE: how to store multiple rows in a stored procedure's parameters and then insert them in a table

  • Here i dont think you need to use any parapmeter with Stored Proc.

    see below code

    create proc p

    as

    select 1 union select 2

    declare @t table (id int )

    insert into @t exec p

    select * from @t

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)