I have an Sql query that correctly outputs negative amount figures.
However, I want to change my report so that anything that is less than
zero is replaced with a zero and therefore summed as zero.
Grateful for any help

Any comments on MySQL as a suitable back-end SQL database for a Web
application? Can it handle possible multiple simultaneous queries and
tens of thousands of records? If not, any other recommendations,
preferably open source?

in this pdf i would like to know what mean "workload"
http://rakaposhi.eas.asu.edu/ullas-widm.pdf
a part of the text
The difculty here is two-fold. First is identifying additional queries over

I have a few tables that are queried intensively yet need to store a
large amount of data (for record keeping queries). Although only about
5000 tuples / 24h will be entered per table, records could be required
for years. It is easy for me to identify data that is very seldom

I am in the early stages of a large (not necessarily complex, I hope)
SQL database project. The early testers want me to provide them some
views similar to the one shown. Since bhid occurs in both JOINed tables
once as the primary key, once as a foreugn key), the CREATE VIEW

Reading about LDAP I think one benefit is builtin SSL support so one
can pont the query from a company in SF to an LDAP server in Miami. Is
there a way to install/setup JDBC drivers so an SSL connection can be
used to ensure the security of the queries? I can think of how to do

I'd much appreciate pointers to some introductory material about dimensional
modeling, ERD and how they compare to relational databases; I'm familiar
with the latter.
A Web tutorial would be great as would online articles.  I think something

If we have a table that has say three columns - id, a, b and we want to
return all rows that have b=1 and b=2 for every equal value of a, then how
can we do that without a divider query (which I MYSQL doesn't do). I maybe
haven't explained that very well, but say

What is the difference between Decentralized and Distributed
Databases? Are they technically synonymous?

A number of years ago, I had heard that Joe Clecko's books were the best
place to start for SQL.
What are the recommended beginning, intermediate and advanced SQL books
these daze?

i try to use SQL Workbench/J under linux with firebird...
i don't have any firebird created, i writed test.gdb for the url...
don't know if will create it..
i have download firebirdsql file who include  firebirddmx.jar,

I don´t know how to run various querys in an atomic fashion without
the use of
transactional tables.
(i.e.) The following queries must be atomic at all:

I have been using Lotus Approach to develop databases but want to get
into developing standalone databases.
What is the best developer program to do this?
I am interested in developing programs that:

Aside from table partitioning which is supported by Oracle (and to a
lesser extent, by PostgreSQL through partial indexes), what are the
other techniques currently employed by RDBMS products to let users
manage large tables (10+ millions of rows) quickly?

I am trying to build a client application using the C API.
The MySQL libraries are *.lib's but the `gcc' I am using
looks for *.a's (I do have -L options set).
In particular, the MySQL documentation advises to use: