>OK. Looks like trigger fires once and
>
>SELECT @Invoice_No = Invoice_No, @COut = Checkout, @CIn = Checkin, @FKey = RunH_FK, @PKey = PKey FROM Inserted
>
>returns 3 records.
>As opposed to firing 3 times and returning 1 record each time.
>Am I right?
Yes :o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
