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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2011-08-04 : 09:39:37
|
| Hi Expertsin my procedure i have the two update statementswith diffrent conditions,these updations happening to same tablesome times one of the updata is not happening( when i executedted)is there any possibility to happen like thisif it is there then how can i resolve this |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-04 : 09:53:02
|
| are you getting some error? if not, check if you've data that satisfies the condition for undergoing update.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2011-08-05 : 03:43:22
|
| i am not getting errorthe procedure is running successfullyi am missing one updation, it happening very rare cases only |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-08-05 : 04:00:42
|
could it be you have NULL value and your WHERE condition didn't handle it ?just a wild guess. . . . We have no idea what your update query is doing nor how is your query looks like nor your schema, nor any sample data nor any expected result. . . . .
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Updation is not happening