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.
| Author |
Topic |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2007-07-04 : 12:53:15
|
| Hi AllI am trying to import the results of a stored procedure into a table and having no joy. I have tried using the import wizard but am having no joy!Any ideas?ThanksGopher |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-04 : 13:06:40
|
| Should be something like this:INSERT INTO MyTable(... column list ...)EXEC MySprocTable must pre-exist, and only one resultset from MySproc can be stored.Kristen |
 |
|
|
|
|
|
Stored Procedure to Table??