Thank you all for responding.

Yes, DCPeterson, creating that many temp tables is what I was afraid of.

I will look into Matt's suggestion, but I'm not sure it would...

Hi Jeff, how are you? Long time no talk (actually I have not posted anything here for a while until today).

Thanks for responding to my post. That's too bad. I...

okay, thanks Brandie. I give it a try. good lucks on your learning of this.

I see. Thanks much Gail. I usually see the user login on it, so that

is why I thought it is strange that it says 'dbo'.

Yes, please write if you can. I think a lot of people in the SQL community

would be greatly appreciated. No pressure, off course :).

Stay true like you have...

Thank you Jeffrey. I did not think that the website would allow attachement,

for the security reason, but that is good to know. Thanks again.

Thank you very much Flo...

Jeff, you probably don't remember, but you helped me once, and I have a tremendous

respect for your technique, knowledge, and for helping me.

I really think you should write sql...

you're probably right, i doubt that the forum allow attachement.

but can i just copy the code you have here and put it in a

class, compile it and use it?

Thank you both Flo and Jeffrey.

I did download the PowerShell last night, and have a brief look around, and even

checked out one of its introduction tutorials, and I have to...

Thanks for the info. I see what you mean.

I was looking into File System object in SQL to do this,

or using SSIS. But I'll look into PowerShell as well...

Thanks for responding. I wanted to do it in sql to housekeep some admin task in sql.

besides, i don't know dos and other command programming to maintaint it.

No problem. I have never seen a sample generated that way before, it's pretty smart of you. So, that is why I got confused of the update statement for the...

Thanks very much Flo. I really appreciate you take the time

and help me out.

Thanks a lot Flo for responding. I'm sorry I ask this because I'm not familiar update in batches, but where would my update statement of the table I need go...

I figured it out now. Tried to delete this post, but for some reason, it won't delete.