Viewing 15 posts - 31 through 45 (of 133 total)
i try to extract valid credit card data. But i was not able to do so ,since data is not in good format.
SQL was never meant to be used...
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 6, 2016 at 10:49 am
in my table, the column names are dynamic ..
SQL does not work this way. By definition, the columns of a table are known and constant and 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
December 3, 2016 at 11:04 am
>> We know what orphans are and you made your point clear. <<
No, we do not. We will have to make assumptions. My guess (and it is only 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 3, 2016 at 10:56 am
The collection of trees is called a forest. A single node by itself is a degenerate tree. Each of the trees in the forest will have a root, so 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
December 2, 2016 at 12:14 pm
Why? One of the major concepts in RDBMS and SQL is to get away from any physical storage. :w00t:
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
November 30, 2016 at 6:32 pm
>> I HAVE A TABLE HAVING THREE COLUMNS <<
Where is the DDL for this table? Why do not the column names follow ISO 11179 rules? What is the key for...
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
November 30, 2016 at 6:30 pm
In the future, would you please follow forum rules and post DDL along with sample data? Depending on what your data actually looks like, you will need to use some...
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
November 30, 2016 at 5:44 pm
>> I need a query to find out all orphans over a hierarchical table <<
``
I never heard this term before, and I wrote the standards. I think you are trying...
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
November 30, 2016 at 5:42 pm
Thank you for trying to post DDL. But tables must have a key, by definition. You have mixed data and metadata in the same table; a measurement name and 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
November 21, 2016 at 9:12 am
You have no idea how SQL works and you need to stop what you are doing, and take some time to do more research and studying. Look up what 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
November 21, 2016 at 8:34 am
You have no idea how SQL works and you need to stop what you are doing, and take some time to do more research and studying. Look up what 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
November 21, 2016 at 8:33 am
>> I guess that the MAX(rowCreatedDT) will execute 3 times in this SELECT. Since there isn't an INDEX on rowCreatedDT and the table has more than 4 million rows. This...
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
November 21, 2016 at 8:30 am
The error message makes perfect sense and is quite clear. What are you taking a maximum of? Where is the group by, or over clause?. See you can find 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
November 18, 2016 at 9:13 am
SQL programmers hate triggers, because they are procedural code and this is a declarative language. Anything you can do to avoid them is good. But I also see you do...
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
November 15, 2016 at 12:56 pm
>> So I have a stored procedure <<
Why? You are doing a computation, so if you put it in the view. It will always be correct, it will port. Since...
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
November 15, 2016 at 12:39 pm
Viewing 15 posts - 31 through 45 (of 133 total)