Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jeniferous
  • Content: Threads
  • Order by date
  1. Jeniferous

    Updating columns within a group where any line meets a criteria...

    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...
  2. Jeniferous

    Update Set Where - multiple rows of validation!

    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...

Part and Inventory Search

Back
Top