View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:31 PM
charliek
 
Posts: n/a
Default Dumping incremental changes to textfile

I was wondering if there is a way to schedule a tast that will dump a
fixed width text file of all the new entries in a table. So if I had
a table with like

username - varchar(20)
created - smalldatetime

I could get a weekly feed each week of all the new users in a text
file. I know I could write a script that would go through and do this
by looking at the time stamp, and the last time that the file
previously ran and get the new dates but I was hoping there was a
built way to do this. Or perhaps a more elegant solution.

Thanks,

Charlie
Reply With Quote