Viewing 15 posts - 136 through 150 (of 596 total)
Hmmm. I agree with what Andy is driving towards, but I'm not too sure about his starting point. To answer a couple of points...
The last time the business asked about...
March 22, 2011 at 2:23 am
tpepin (2/10/2011)
February 10, 2011 at 7:10 am
I'd like to reiterate James's earlier point. An article is intended to illuminate or inspire. It's not intended to do a reader's work for him or her. As such, James...
February 10, 2011 at 3:50 am
Andy DBA (2/8/2011)
....Please sell me on any reason beside "clarity of code" or "easy solution" (read band-aid fix) where using SELECT DISTINCT would be preferable to using GROUP BY.
Any time...
February 10, 2011 at 3:28 am
Koen (da-zero) (2/8/2011)
Why? I found that the article didn't introduce us anything that can't...
February 8, 2011 at 2:03 am
karyn.webb (2/6/2011)
majorbloodnock (2/4/2011)
Alan Vogan (2/4/2011)
....If it's fun, does it necessarily make it a toy?...
To my mind, no. I think it's just emphasis. If you're using the surfboard for exercise...
February 7, 2011 at 1:26 am
Alan Vogan (2/4/2011)
....If it's fun, does it necessarily make it a toy?...
To my mind, no. I think it's just emphasis. If you're using the surfboard for exercise and fun...
February 4, 2011 at 8:47 am
Interesting discussion. I would say a tool is an aid to solve a problem, whilst a toy provides its own justification for use. For instance, if you buy an iPhone...
February 4, 2011 at 4:24 am
Well, now you're getting my poor old brain smoking. I had to think long and hard before realising the problem here.
I agree that in a true tree structure each node...
February 2, 2011 at 5:25 am
Adam Machanic (2/1/2011)
majorbloodnock (2/1/2011)
The technical logic is fine, but in practice, why shouldn't an employee have two managers?
Having actually had two managers (and then, later, three) at one point...
February 1, 2011 at 10:42 am
Adam Machanic (1/31/2011)
....Next, a unique constraint on the employee column, so that the same employee can't appear in the hierarchy twice under different managers....
Thereby, of course, hangs a fairly fundamental...
February 1, 2011 at 8:29 am
andy.roberts (1/31/2011)
Something I can't get my head round - can anyone explain ...
    The result of running the first CTE before the circular relationship was added had extra rows...
January 31, 2011 at 10:38 am
Perhaps more pertinent in criticising AD is its accessibility. ADSI and LDAP are technically effective, but hardly user-friendly.
January 31, 2011 at 7:56 am
gerg-520419 (1/31/2011)
WITH GroupMembers (Bottom, Child, ParentGroup, Level, hierarchypath)
AS
(
-- Anchor member definition
SELECT g.child as Bottom, g.child, g.parent, 0 AS Level, convert(varchar(max), g.child + '->' + g.parent) AS...
January 31, 2011 at 4:13 am
Peter.Frissen (1/31/2011)
Suppose I want to return not only the leaf-to-parent relation, but also any subparent-to-parent? For example, b...
January 31, 2011 at 4:10 am
Viewing 15 posts - 136 through 150 (of 596 total)