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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 multiple row updates

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-11 : 00:02:07
Chris writes "i write a lot of system monitoring (integraty checks, updates) queries/scripts. the query i'm working on now compares a number of tables, gives me the results for one colunm(the same column from each of the tables), and updates a specific table with the data it returns. now the problem i'm having is when the query returns more than one value, i can't seem to get a multiple-row update to work. one row updates are no problem. can you help me out?
thanks
chris"
   

- Advertisement -