Computer Woes

Last weekend was a bad computer-weekend for me. My laptop locked up 30 times (no joke) so I started rebuilding it on Sunday. Now today is Thursday and I'm almost done. Good thing I can work on another system. The reason it is taking so long? I applied an update to my Intel chipset from Dell and it locked my system back up yesterday (to the point where it would no longer boot). So I started it over yesterday. I am back to a basic installation with all my system drivers installed and MS Office (plus a few basic apps). I'm afraid to install Visual Studio again. Previously I had VS 2002, 2003, and 2005 beta 1 installed. For some reason, beta 1 worked better than 2003 (which is why I had to reload in the first place). Oh well.

Adobe buying Macromedia?

I have to say I was a bit surprised to read this. I will be very interested to see what the outcome of this aquisition will be both on the other players in the market and on the pricing structure of Macromedia products (such as Breeze). Ah well, time will tell.

Delete Child Table Rows Using Parent Table Rows (SQL)

I ran into this article when working on a deletion of child records using a parent record's fields for evaluation. Hopefully someone else will find this useful too.

You can find the article by Thom Pantazi here.

I did alter his code a bit as I was about to delete all rows from my child table instead of the ones that matched my criteria. Here is my final statements:

DELETE ChildTable

WHERE ParentId IN (SELECT ParentId FROM ParentTable WHERE Criteria = 1)



DELETE ParentId WHERE Criteria = 1