Testing Conditions to set status on the fly
Posted on 2012-12-26
I have a table that holds orders. One order can take up multiple rows, and each item can have its own status within an order.
What I'm trying to do is figure out a way to look at each row, and if all the status' equal 1 to code the order status as 'Placed' If there are two items marked as shipped but one as placed, the order status would be In Progress. Similarly, if all item status' equal Shipped, then the whole order is marked as shipped.
Not sure where to start on this.