Viewing 15 posts - 241 through 255 (of 386 total)
Koen Verbeeck (3/30/2015)
;WITH
I hate it :-D/quote]
I totally agree! This leads to sloppy code development and debugging nightmares. Besides, it's ANSI standard...
March 30, 2015 at 7:51 am
Gary Varga (3/23/2015)
March 23, 2015 at 9:19 am
David.Poole (3/10/2015)
March 11, 2015 at 6:54 am
Andrew..Peterson (3/10/2015)
cdesmarais 49673 (3/10/2015)
I currently support Mongo, SQL Server, MySQL, and increasingly PostGres, which offers an interesting hybrid document db datastore on top of a relational db.
Great, so...
March 10, 2015 at 11:21 am
It all comes down to this: use the right tool for the right job. NoSQL databases have their uses and function well in that space just as RDBMS databases...
March 10, 2015 at 6:35 am
Brian Hibbert (1/30/2015)
SOME and ANY are operators rather than standalone functions even though they look like functions.
I believe that this is consistent in style with operators such as IN.
January 30, 2015 at 10:30 am
Good introduction Steve! I've never used the SOME function before.
I think it's also pertinent to point out that the reason all 8 rows returned was because of the use...
January 29, 2015 at 7:10 am
I have to agree that in most business organizations, the IT department is treated pretty much the same as the maintenance department. It's always seen as a cost center,...
January 22, 2015 at 7:09 am
Yet, not surprising when you consider that the parent table has 1.85M rows, the child table has 7.5M rows, and the validation table has 54K. The indexes were optimized...
January 14, 2015 at 12:31 pm
Chris' solution works well in environments with low to medium data volume, but in the very high data volume environment I have it's too slow. I'm considering other alternatives.
January 14, 2015 at 10:52 am
Serg,
You are correct that it essentially transforms the INNER JOIN into a sub-query.
SELECT A.Item, B.Descr, C.Color
FROM (SELECT 1 as Item UNION ALL SELECT 2 as Item UNION ALL SELECT 3...
January 14, 2015 at 8:59 am
serg-52 (1/13/2015)
OK, may be just filter them in WHERE ?
Unfortunately, that would filter out rows, not columns.
January 13, 2015 at 7:43 am
ChrisM@Work (1/13/2015)
Firstly, the FROM list of your query, which looks like
SELECT ...
FROM parent
LEFT JOIN child to parent
INNER JOIN grandchild...
January 13, 2015 at 7:41 am
Ed Wagner (1/12/2015)
They must want someone who knows things by the book instead of someone someone who knows the technology by using it. :sick:
That's why I have a huge...
January 12, 2015 at 11:16 am
It is indeed a good question. However, I think the requirement of a primary key was a bit misleading as it can also occur when the field is simply...
January 8, 2015 at 6:23 am
Viewing 15 posts - 241 through 255 (of 386 total)