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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
need code to find most common
Thankyou so much. :) I can now crack on, hopefully i should be ok now I owe you -
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...
