SQL Server Performance

SP in SQL Task

Discussion in 'SQL Server DTS-Related Questions' started by deepak_khattar, Feb 13, 2004.

  1. deepak_khattar New Member

    Hi,

    I wish to execute sp_help_job and wish to store output as ROW SET. As I click PARAMETER BUTTON I get msg saying "NO PARAMETER".

    I know the reason but is there better way of doing than creating TEMP tanble and insert records from SP into table and select data from temp table.

    Thanks

    Deepak


    Deepak Khattar
    DBA
    World Health Organisation
    Geneva, Switzerland
    deepak_khattar, Feb 13, 2004
    #2

  2. satya Moderator

    Its better to use TEMP table or can use TABLE datatype for that instance.
    REfer to BOoks online for TABLE datatype information.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Feb 17, 2004
    #2

Share This Page