Take Procedure result into user table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Take Procedure result into user table

Author

Topic

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2010-05-10 : 07:47:21

Hi All

I want to take the procedures resulted columns into my table.For example
I have my own table thats is indexes ( indexname varchar(100),indexdesc varchar(100),indexkey varchar(100))

I am running sp_helpindex 'sysdba.account'

It is giving three columns and i want to put this columns in my table

Please help me on this

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-05-10 : 07:56:48

[code]
insert into indexes
exec sp_helpindex 'sysdba.account'
[/code]

KH
[spoiler]Time is always against us[/spoiler]

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2010-05-19 : 13:38:13

Hi thanks for reply...I have one more question i have one more table

create table #jobactivity( job_id uniqueidentifier,
category varchar(50),
last_run_date int,
last_run_time int,
next_run_date int,
next_run_time int)

i am trying to populate this table using this command
insert into #jobactivity exec msdb..sp_help_job

but is is not working.Do i need to add same no of columns into the table? i want to take the selected columns into the table..Please help me on this.

quote:
Originally posted by khtan

insert into indexes
exec sp_helpindex 'sysdba.account'

KH
[spoiler]Time is always against us[/spoiler]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-05-19 : 18:21:50

for "insert into . . .exec . . " the table columns must matched the result of the exec

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources