Viewing 15 posts - 1 through 15 (of 133 total)
Of those a really good article because people are not aware of problems with statistics. The classic book on this is "how to lie with statistics." By Darrell Huff. It...
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
January 10, 2017 at 2:24 pm
Of course, JC would use the INFORMATION_SCHEMA views, because they're part of the SQL standard. However, my knowledge is not enough to know how to identify the constraint...
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
January 9, 2017 at 10:33 am
I notice that you avoided the question of how to produce a report of sports that do not currently have any participants.
Here is a little different way of doing...
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
January 9, 2017 at 10:29 am
I have to write a query that lists orders and partitions them by customer id# and displays the something_date, customer_id, generic_name, order_amount and something_count on each line (sic).
We need...
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
January 7, 2017 at 6:37 pm
I see absolutely no benefit to having this as a check constraint rather than as a foreign key constraint.
The check constraint can be used by the optimizer immediately; it is...
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
January 7, 2017 at 5:08 pm
Having a new sport shouldn't require a DDL change. Getting a list of available sports shouldn't need to remove duplicates.
I would make the argument that the list of available...
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
January 5, 2017 at 3:10 pm
I have been teaching SQL for over 30 years. In that time I found that if you do not give a newbie all the information that they need, they tend...
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
January 5, 2017 at 11:43 am
You are right. Let us post a correction i just got in a hurry. My bad.
CREATE TABLE Players
(player_id CHAR(5) NOT NULL PRIMARY KEY,
first_name VARCHAR(10) NOT NULL,
last_name VARCHAR(10) NOT NULL);
CREATE...
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
January 5, 2017 at 11:27 am
>> Below is the table and results I am looking for......i am an SQL newbie. <<
please read the forum rules about how to do a posting. Your narrative should have...
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
January 4, 2017 at 9:45 am
You really need to get a book on basic RDBMS because your approach is completely wrong. You also fail to post DDL; please read the forum rules and learn about...
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
January 4, 2017 at 8:38 am
>> I'm pretty new to this and am in need of some help writing a query. I'll try to explain. <<
Do not try to explain things by telling us a...
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
December 28, 2016 at 11:43 am
I have to group these records [sic: rows are not records] together - the above data creates two groups :
Group 1 --> ProdA, ProdB, ProdC
Group 2 --> ProdD, ProdE...
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
December 23, 2016 at 8:50 am
those were slanders aimed at me; I might do "ignorant"when I am talking to someone, but I will back it up with evidence. I believe I can present evidence that...
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
December 19, 2016 at 10:25 pm
, I (and many others) get really pissed off when people make illiterate/ignorant claims like "an order clause converts a set into a cursor".
Illiterate and ignorant? Which 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
December 18, 2016 at 12:16 pm
This is usually not a good design. For the painful details read this:
https://www.simple-talk.com/sql/t-sql-programming/bit-of-a-problem/
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
December 14, 2016 at 1:27 pm
Viewing 15 posts - 1 through 15 (of 133 total)