Not a .net question, more of a enterprise manager question.
I have a task running each night that compares 2 tables and deletes
items from table 1 if they are not in table 2. What I would like to
have happen is to before I do my delete, do a select statement and
store those results in a temp table before I do the delete...just
incase an errors happens along the way. My problem is, I don't know
how I can loop through a query and put those records into a table by
using a job in the sql server agent. Would it be eaiser/better to
setup a DTS package and do it in steps that way?
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
