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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-12 : 18:32:58
|
| Vidais writes "I have generated a cursor, which contains the results of an operation.i want to append the results at a goal to a table in sql server.What is the approach.sql server 2000" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-12 : 19:14:06
|
| The best approach is to not use the cursor. Please post your code so that we can help.Tara Kizer |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-13 : 09:57:25
|
| If your temp table to have data, you can doInsert into TargetTable(columns)Select columns from #tempMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
inserting the content of a cursor into sql datable.