Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Better way of conditionally updating many rows
Thanks johpje, unfortunately only the last case applies to my problem. At least the IN keyword makes it look a bit nicer. But I suppose i'll need to rethink the whole process and do something more clever. Introducing another table might be a good idea actually. Another option might be setting...- 10409
- Post #3
- Forum: -General database discussion
-
Better way of conditionally updating many rows
Hi, I've got a quite big Table of User-Sessions with basically an ID and an END_TIME, for when the Session ends (a date). Now, outside the Database, I've got an also quite big list of Session-IDs, that have to be kept alive, by updating the END_TIME. This list is in Java. How would I do this...- 10409
- Thread
- Replies: 2
- Forum: -General database discussion
