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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-10-02 : 17:14:11
|
| hey sqler'sI have an easy query question, but I am really stupid today (or all the time).i converted a bunch of old data into a new system, i was told a specific date was the "exit date" therefore allowing me to exit the person in my database.Well,I need to run updatesthat essentially do thisupdate CaseInfo set exitdate = NULL , active = 'No'where -- pseudo sql to follow count from EnterContract is greater than count from ExitContract (for each caseinfoid)should I just use a cursor to loop through each caseinfo recordget count from the to contract tablesthen update the caseinfo table's exit data?I am a rookie in sql, and in dating women for that matter._________________________Death is one day closer |
|
|
|
|
|
avoiding a cursor again