SQL 2005:
Problem:
I have a table of Items (Items) that has FK in table of order items (orderItems). Both of these tables have a unitPrice field. I need to update the orderItems - unitPrice if it is different from the Items - unitPrice. It needs to be set to the value in the Items - unitPrice field only if they are different.
Thanks in advance!
Start Free Trial