1. How does SQL delete when it deletes in bulk?(like cascade delete of child tables)?

2. How do i loop the deleted items in the cascade delete table?
   This trigger works well in single delete but doesnt loop
   in bulk deletes. Can anyone Help?
   Sample Trigger:

CREATE TRIGGER UpdatePRPOed_D ON dbo.pur_tblpodet FOR DELETE AS

UPDATE mat_tblPurchaserequisitiondet
    SET mat_tblPurchaserequisitiondet.POed =
        mat_tblPurchaserequisitiondet.POed -
                (SELECT QTY FROM deleted
                WHERE PRNo = mat_tblPurchaserequisitiondet.PRNo AND
            StockCode = mat_tblPurchaserequisitiondet.StockCode)

    WHERE (mat_tblPurchaserequisitiondet.StockCode =
        (SELECT TOP 1 StockCode
        FROM deleted
        WHERE PRNo = mat_tblPurchaserequisitiondet.PRNo))

__________________
Proud To Be Pinoy