You have some basic errors in the DDL you posted. A table has to have a key, but you have none. And no way to ever have a key because...

Instead of trying to repair the damage after it has been done, you can add...

>> My table look like this, <<

Your DDL did not print; all we got was a gray bar in your posting. But what you did post in the way of...

The usual idiom for this is a CASE expression the usual idiom for this is a CASE expression. I am assuming that you want only one of the three predicates...

>> I have a set of agreements that have a date the agreement was started. From those agreements I track activities that occur during 3 month periods starting from the...

Why? Does it really go down to seconds and nanoseconds question? Should not you be using the DATE instead?...

The error message is pretty straightforward; the replace () has to have the target, the old string and the new string.

You really need to clean up the data instead of...

The money datatypes were created by Sybase in the original SQL server for COBOL programmers. In COBOL, they have a PICTURE clause in their file declarations, which hold display formatting...

There is little problem here. Time actually goes from 00:00:00 Hrs to 23:59:59; there is no 24:00:00. The ISO 8601 model is based on half open intervals. IBM is had...

All display formatting in SQL is done in a presentation layer, never in the database. If you will read the SQL standards, you will find that we use only one...

The terms "parent" and "child" belong to network databases and not to SQL. We have "referenced table" and "referencing table"; a reference can be a self reference to the table...

I almost forgot that when we added the OLAP functions, became pretty close to Dr. Codd's two kinds of null. We have a null. That is in the actual data,...

Nope. While the ISO...

(start_date, end_date) pairs the idiom has been that a null in the end_date means "eternity"in that context

My experience has been that it means one of two possible outcomes:

1) Eternity in...

Nulls are actually both! :w00t: The original definition from Dr. Codd was that they are a marker for a missing value. But that changed later in the second version of...