View Single Post
  #7 (permalink)  
Old January 17th, 2008, 12:17 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I understand.

I would use the structure I have suggested since this will look the needed flag into the record until it can be processed.

One more question, is there ONE record in Table B and many in Table A, or vice versa? In other words, are you taking many records in Table B, finding the most recent ServiceDate, and putting it into one record in Table A, or are you taking one unique record at a time from Table B, and then updating one unique record per in Table A?

The answer has a big effect on the final code structure.

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote