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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help on Update Statement
Hello, I needed some help on how to set records that where cancelled. Here is the table (Orders) and the relevant fields: Orders Order_ID (VARCHAR(25))[/*]Cancelled (BIT)[/*] Using the Order_ID, what I need to do is to find any orders that were cancelled and its corresponding original... -
How to update a field while inserting a row
Hello, I wanted to know what would be the best way to update a field of a row while I am inserting. Here are the tables and fields (for simplicity I am only including relevant fields): • firms ⁃ firm_id (integer, autoincrement, primary key) ⁃ firm_code (varchar(25), internal code) ⁃ name... -
Trying to get MIN MAX with CASE statement
Hello, I am trying to generate a summary report using various aggregate functions: MIN, MAX, SUM, etc. The issue I have is when I try to get a MIN and MAX of a field when I am also using the case statement. I am unable to get the MIN value of a field when I am using the case statement. I...
