>How can U select from a table the modified records of yesterday ?
Not that way. Put a field named LastModified DateTime allow NULL and on each update update that field with GETDATE(), then selecting the modified records for some date or even period will be easy.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
