Viewing 3 posts - 1 through 3 (of 3 total)
Update <tablename> set sent = 1 where datecreated BETWEEN DATEADD(hh, -2, GETDATE()) AND DATEADD(hh, -1, GETDATE())
May 17, 2006 at 12:43 pm
#638530
Or you could create a DTS package having an activeX script component to find and assign the text filename dynamically using filesystemobjects.
May 11, 2006 at 6:40 am
#637212
Have you thought about using a DTS package to accomplish this? Try going to 'Tools' -> 'Data Transformation Services' -> 'Export Data' and go through the wizard to create your...
May 11, 2006 at 6:37 am
#637210