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 |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2005-06-20 : 10:39:39
|
| Hello, My procedure returns same values. i want to insert this values into same table. is there any way i can do that without using the variables. ThanksComplicated things can be done by simple thinking |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-06-20 : 10:43:31
|
| INSERT INTO MyTable (Col1, Col2, ...)EXEC MySProcTable must pre-exist (You can't do a SELECT * INTO MyNewTable FROM MyOldTable type deal)Kristen |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-06-20 : 10:43:33
|
Is this what you mean?insert myTable (<colList that matches SP output>)exec mySPBe One with the OptimizerTGoooh,  by 2 seconds! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-06-20 : 10:45:46
|
| Hehehe ... your <colList that matches SP output>) is invaluably info. thoughKristen |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-06-20 : 12:09:01
|
Thanks Kristen it helped  Complicated things can be done by simple thinking |
|
|
|
|
|
|
Redirecting the procedure output to Table