Viewing 13 posts - 31 through 43 (of 43 total)
How can I tell the difference between a triangular join and a linear join?
The closest I haev been able to come to understanding this is my reading Jeff Moden's article...
September 11, 2008 at 7:58 am
Grant Fritchey (9/10/2008)
Why don't you now go one step further. Replace the #AD with the query that defines #AD
SELECT...FROM (SELECT... FROM xxx) AS a
UNION...
In my original post, the code block...
September 10, 2008 at 9:49 am
Here is another solution sent in a private message.
SELECT a.PointName
FROM #PointTable a
WHERE
( SELECT Count(*)
FROM #PointTable aa
...
September 10, 2008 at 9:27 am
Grant Fritchey (9/10/2008)
Or, rather than hard coding all those values in a query, create a table and store them there. It'll sure make maintenance easier.
Let me clarify something. In...
September 10, 2008 at 6:16 am
Steve Jones - Editor (9/9/2008)
Why not just use the SELECT UNIONS instead of the temp tables in the select? It appears that you're using static values in there.
I did not...
September 10, 2008 at 6:12 am
I understand that this is a long question. Any assistance in explaining the concepts behind a good answer is much appreciated. I'm kinda new at this stuff.
September 9, 2008 at 7:54 pm
Thanks for the reply, GSquared. This is much better than what I came up with. :w00t:
A related question: Isn't "X between Y and Z" a double triangular join, which...
September 9, 2008 at 2:54 pm
WayneS (8/21/2008)
anil_mootha (8/20/2008)
Hi Paul,It looks like nobody's bothered to answer our question. To me till I don't get a satisfactory answer, this topic doesn't make any sense!
Have a wonderful day!
I...
August 21, 2008 at 6:19 am
WayneS (8/20/2008)
Paul DB (8/20/2008)
anil_mootha (8/20/2008)
Why would you prefer to build XML strings manually when you can do it with FOR XML statement.
The very purpose of FOR XML statement would be...
August 20, 2008 at 8:39 am
anil_mootha (8/20/2008)
Why would you prefer to build XML strings manually when you can do it with FOR XML statement.
The very purpose of FOR XML statement would be void otherwise.
Thanks and...
August 20, 2008 at 6:12 am
That was an amazing article. :w00t: Thanks so much, Jeff.
August 19, 2008 at 6:29 am
Jeff Moden (8/12/2008)
Paul DB (8/12/2008)
Jeff Moden (12/5/2007)
I should have mentioned that I'm working on an article (may end up being...
August 15, 2008 at 10:30 am
Jeff Moden (12/5/2007)
I should have mentioned that I'm working on an article (may end up being two) that covers a...
August 12, 2008 at 10:00 am
Viewing 13 posts - 31 through 43 (of 43 total)