That makes two of us. I think I was still in some kind of weird complicated
SQL mode from rewriting a bunch of my stuff lastnight and I didn't bother to
think simplistically this morning. Figures... I'm surprised I missed
something so trivial.
Oh, I also noticed that Charges.Tax is null for all entries (we don't use
tax, so it's not a big deal)--should these be updated to 0.00 instead (as
was necessary with Invoices)?
Josh
>
>Update ii
>Set ii.Quantity = 1
>From InvoiceItems ii, Charges c
>Where c.ItemID = ii.ItemID
> and ii.Quantity > 1
>GO