He is obviously new to SQL Server and really needs to start doing some research instead of asking such broad based questions like this one.

And in what manner are you talking about? That too is a big topic. It...

Just seems a bit out of my usual SSC character. I'm usually the one trying to everything I can to help people and then I lmgtfy twice in one...

I think that really comes down to a personal choice. When I registered on SSC, I just decided it was easier to use my name. Plus, I couldn't...

Care to elaborate? Your question was pretty vague and SQL Server 2005 is a mighty big topic.

Jeff Moden (6/9/2009)

Which tread? I...

Is the day portion always 2 characters, in other words you don't have 1109 (mdyy)?

Cross posting won't help you get greater responses. It will just fragment the responses you get.

Additional thought. If you were able to automate such a delete/update routine, what if a delete were done by mistake? How would you recover the accidently deleted/updated data...

Not possible, and doesn't make sense to do it in my opinion. You'd have to restore the every backup to determine if the data existed, then delete it, then...

Alvin Ramard (6/9/2009)

I don't think that's...

I really hope you have more than three columns in this table. there is no order assumed in a table, so what determines the order of the rows in...

Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...

Really? Here, let me Google that for you also.

Unfortunately, I have no idea. How is the data being moved from the staging table? Are you using SSIS, T-SQL Query?

It would help to have more in depth...