How to insert a result into 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

SQL Server 2000 Forums

SQL Server Development (2000)

How to insert a result into table

Author

Topic

sujith
Starting Member

20 Posts

Posted - 2005-06-08 : 07:44:59

How to insert the result set of an extended stored procedure into a table in the database?

The result set of the sproc is in tabular form. I want it to be inserted into a table. How it can be done?

Sujith S

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-06-08 : 08:28:57

Select column1,column2,column3 ...... ext
Into Yournewtable
From youroldtable

Jim
Users <> Logic

sujith
Starting Member

20 Posts

Posted - 2005-06-08 : 08:55:15

Thanks for ur reply. Actually I was using xp_readmail

use master
insert into yourdb.dbo.yourtable
Exec xp_readmail

Sujith S

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources