My very general advice would be to stick to base tables and not use any of the features outside of the ANSI ISO standards for creating tables. Essentially, this advice reduces...

>> Today I learned that GROUP BY and COUNT() do not pay attention to "THEN" in the CASE statement [sic]. I thought it would count what I set the value...

After doing this for about 50 years, I found the best way to handle names is to get a specialized piece of software for them and use it to scrub...

Yes EU. I dictate most of my correspondence these days because my hands are such a mess. First I couldn't live without a spelling checker, now I sing praises of...

Please do some research and look up the E you rules for triangulation. This means that you have to convert from currency A to Euros, then from Euros to currency B. There...

This is going to be more work than you think it is. I would strongly recommend that you get a package designed to handle names and addresses, such as Melissa...

In the future, you might want to follow the netiquette that is been established for over 35 years in SQL forums. That means posting DDL. Because of your lack of...

>> The point being that, at it's core, this is a math problem. Storing pre-calculated values makes about as much sense as storing multiplication tables. <<

I hate to tell you...

Back in the old days, we attend lookup tables for this kind of stuff. Since SQL is designed for looking up data in tables, instead of doing recursive loops and...

>> I have a column [batch_date] that contains dates in text format: <<

The only format we allowed in ANSI ISO standard SQL is based on the ISO 8601 standard (yyyy-mm-dd)....

>> hello I have a table similar to this:<<

What you posted was not a table. By definition, a table must have a key. You also don't seem to know the...

The error message pretty well explains itself. But because you didn't bother to post DDL we would just be guessing at anything, or trying to write the DDL that you...

>> I am trying to understand why I have to GROUP by all of the fields[sic: columns] in my SELECT Statement. Also, the query is returning the sum for all...

One of the major ideas of client/server architecture was that the system would come in tiers. The database layer would get a result set, then pass that set on to...

Have you considered using a relational design instead of this mess? There is no such thing as a generic category in RDBMS; we follow the first law of logic that...