SQLTeam.com | Weblogs | Forums

Select and Update mismatch

Hi,
I have a select statement which returns 1 row. When I try to update the same row (same table, same where clause), SQL server shows 3 tables being updates (I see (1 row affected) 3 times).
I believe it is due to "update cascade" ? If yes, how do I find out if a table is set up for "update cascade " ? or anything else I am missing ? Please help. Its a simple straight forward SQL with one table only.

If you are sure it is a table and not a view then maybe there is a trigger causing the updates. Or maybe the table has a field with a calculated column. Your not using a SELECT DISTINCT or a GROUP BY command in your select statement? Without some example data it is hard to guess :slight_smile: