I was running an update to calculate the extended cost along the lines
set cost =
where maintable.product_id = product.product_id)
where month = 3 and year = 1996
I got a DB-Library process dead error every time I ran this update. Is
it an illegal statement or is it another bug in MS_SQL?
BTW - It worked fine when I removed the *maintable.quantity and ran it as
a separate update on maintable.