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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-06-16 : 11:37:54
|
| Hi guys..I am giving the following command, it is taking so much of time..insert into lkp_static_data select * from results14resulut14 table is having the following 3 records..PRICE_TOLERANCE_OPT POETIC Use Poetic calculated price. Ignore requested price. NULL NULL NULL -1 NULL NULL NULL 1 0 2056.000 10000081079PRICE_TOLERANCE_OPT REQ_TOLR Use requested price if within allowed percentage of Poetic calculated price. NULL NULL NULL -1 NULL NULL NULL 4 0 2056.000 10000081080PRICE_TOLERANCE_OPT REQUEST Use requested price. Ignore Poetic calculated price. NULL NULL NULL -1 NULL NULL NULL 3 0 2056.000 10000081081Could u tell me why it is taking much time.. and what is the remedy..Thanks in advance. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-16 : 12:47:48
|
| What is a long time?Check for triggers on the destination table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-06-16 : 16:49:56
|
| It is better to explain the table design. Any BLOB/Image columns are there?With RegardsBSR |
|
|
|
|
|
|
Taking too much of time for insert