Post reply

Use stored procedure result to insert into table

  • March 25, 2015 at 6:24 am

    #398241

    Silly question:

    my stored procedure returns one row. I need to insert the result to a table. Can I right something like that:

    =============

    Insert into table1

    exec myProc '1/1/15', 3/1/15'

    =====

    Or may be I can use Table-valued function insted of myProc?

    Thanks

  • March 25, 2015 at 6:25 am

    #1786250

    valeryk2000 (3/25/2015)

    Silly question:

    my stored procedure returns one row. I need to insert the result to a table. Can I right something like that:

    =============

    Insert into table1

    exec myProc '1/1/15', 3/1/15'

    Yes

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 25, 2015 at 7:58 am

    #1786314

    Yes silly or yes I can?

  • March 25, 2015 at 8:00 am

    #1786315

    valeryk2000 (3/25/2015)

    Can I right something like that:

    =============

    Insert into table1

    exec myProc '1/1/15', 3/1/15'

    Yes

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 25, 2015 at 8:28 am

    #1786331

    Solved. Thanks a lot.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply