Viewing 15 posts - 76 through 90 (of 133 total)
No there won't be any gaps, they must be continuous even if they overlap.
Instead of trying to repair the damage after it has been done, you can add...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 29, 2016 at 5:39 am
>> 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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 28, 2016 at 2:49 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 28, 2016 at 1:58 pm
>> 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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 26, 2016 at 9:25 am
Got a Column "funding_date DATETIME" ( has date as well as timestamp).
Why? Does it really go down to seconds and nanoseconds question? Should not you be using the DATE instead?...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 21, 2016 at 8:11 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 21, 2016 at 8:00 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 20, 2016 at 12:29 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 19, 2016 at 8:42 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 19, 2016 at 2:32 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 17, 2016 at 7:19 am
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,...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 14, 2016 at 2:39 pm
Actually, the SQL standards support TWO date formats, not one. 'YYYYMMDD hh:mm:ss' and 'YYYY-MM-DDThh:mm:ss'. (I'm not showing all the decimal places for the seconds.)
Nope. While the ISO...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 14, 2016 at 1:16 pm
(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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 13, 2016 at 8:30 pm
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...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 13, 2016 at 2:05 pm
This is a direct cut and paste from "SQL for Smarties", you will have to figure out where the data in the tables and stuff should go. But it looks...
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
September 13, 2016 at 12:06 pm
Viewing 15 posts - 76 through 90 (of 133 total)