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 |
|
JNotenboom
Starting Member
27 Posts |
 Posted - 2001-03-07 : 03:35:30
|
| Hi,My problem is the following:I have a table with four columns:SalesRepName, TerritoryID, PotSales, MaxPotSales.1 territory has one or more Sales representatives.All PotSales are filled in.I want to do the following:- Find the maximum of PotSales (MAX(PotSales) for each territory.- update the column MaxPotValue with this value for every record concerning that territory.any ideas?regards,JohanwannaWAP.com |
|
|
|
|
|
Update column in table with max value