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-02-17 : 08:42:27
|
| Bhumika writes "1.When i am calling procedure from transaction it is giving any error of TIME OUT as i have checked there are no syntax error in the sp but still it is giving error of Time OUT2. When fetching the record through cursor do i need any temproray table to stored that data before inserting in the another table" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-17 : 09:09:02
|
| 1 http://vyaskn.tripod.com/watch_your_timeouts.htm2 If you want to copy data from one table to other. You dont have to use cursor. Use thisInsert into targetTable(columns)Select columns from SourceTableMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Query Regarding Sql Server Stored procedure