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 |
|
yossibaram
Yak Posting Veteran
82 Posts |
 Posted - 2002-12-05 : 04:04:53
|
| Hi,I use a SP that Update a table with values.I am using the following update: UPDATE Product SET Product_num = LanTable.ProductNum, Sticker_Type =LanTable.StickerType FROM Product p JOIN LanTable ON Lantable.ProductNum = p.Product_num I want this update to skeep identical records that need no update.Running this SP in a qeury analizer shows me all records is updated even if values are the same- its slowing down the performance.Can i change it?Thanks |
|
|
yossibaram
Yak Posting Veteran
82 Posts |
Posted - 2002-12-05 : 04:50:06
|
quote:
Hi,I use a SP that Update a table with values.I am using the following update: UPDATE Product SET Product_num = LanTable.ProductNum, Sticker_Type =LanTable.StickerType FROM Product p JOIN LanTable ON Lantable.ProductNum = p.Product_num I want this update to skeep identical records that need no update.Running this SP in a qeury analizer shows me all records is updated even if values are the same- its slowing down the performance.Can i change it?Thanks
No need for help.I managed, Thanks |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-12-05 : 04:50:51
|
| ...ON Lantable.ProductNum = p.Product_num andProduct.Sticker_type <> LanTable.StickerType?I'm not sure that that would be any faster, though.-------Moo. |
|
|
|
|
|
|
Update only records that need update