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 bkrike 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: nutpuk
  • Content: Threads
  • Order by date
  1. nutpuk

    Triggers

    Hi again. Just thought Id ask this question I need to create a trigger to reduce the quantity in stock when a part appears in the invoice line, Ive tried loads of things only to get error after error The tables which i need to use in the trigger are these: I have an invoice line table which has...
  2. nutpuk

    need code to find most common

    Hi I have a table of cars in sql server 2000 eg ford, mazda, GM the list is endless, Im wanting to find out the most common car in the table but I dont know the sql select statement to do it. The cloumn with the cars in is call model and the table is car But i dont know what to put in to find...

Part and Inventory Search

Back
Top