Search results for query: *

I have a table which contains details of stock items. This table might have 7 rows for the same product within different warehouses. The business process states that when a user marks a single warehouse product combo as obsolete (by adding OBS to the start of the description field) that they...

Probably not - i've tried a variety of options from <> to >= to <= to != but it still excludes the line with 0. I turned the above inot a select statment and it bought back everyline except the one with a 0... so its ignore it rather than setting the status E.

Tried the above and it still marks the rogue order as Passed even though it has a line on where the net_price is 0.

I thought this was all working till I tested with live data.. what i wanted to do is set the header status to P if all the lines pass but if any line fails then set the header status to E. Here's my code... it's a slightly different check but the same theory as above. Update bs_despatch Set...

Few more tweaks and that worked great! Thanks... i almost understand it too! Just one last thing though - i need to exclude any where the scheme.opdetm.product column is NULL i.e. don't include them in the validation at all.

I've tried both the bottom options above (not sure i understood the first one!) On both i get: Line 5: Incorrect syntax near '.'. Here's my actual code for both (I used examples to try explain myself earlier but here are my table names/fields)... In the second options i didn't quite understand...

Order Header: 080321 080322 080323 Order Lines: Order_no Line_Number Product Order_qty Despatched_Qty 080321 0001 HANDLE 20 20 080321 0002 WHEELS 10 10 080321 0003 TYRES 40 0 080322 0001 WHEELS 2 2 080322 0002 WHEELS 10 0...

I want to set a status field to P where a condition is met in an alternative table. The alternative table contains order lines but there could be more than one order line per order number but the table i'm updating has a single record per order. I've got the below code.... UPDATE OrderHeader...