SQL Server Performance Forum – Threads Archive

SP in SQL Task

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

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.

]]>