Viewing 13 posts - 31 through 44 (of 44 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...
Paul DB
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...
Paul DB
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
...
Paul DB
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...
Paul DB
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...
Paul DB
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.
Paul DB
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...
Paul DB
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...
Paul DB
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...
Paul DB
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...
Paul DB
August 20, 2008 at 6:12 am
That was an amazing article. :w00t: Thanks so much, Jeff.
Paul DB
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...
Paul DB
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...
Paul DB
August 12, 2008 at 10:00 am
Viewing 13 posts - 31 through 44 (of 44 total)