SQL Server Performance Forum – Threads Archive
SP in SQL TaskHi, 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
World Health Organisation
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.