Viewing 15 posts - 136 through 150 (of 597 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...
Semper in excretia, suus solum profundum variat
March 22, 2011 at 2:23 am
tpepin (2/10/2011)
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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.
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
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...
Semper in excretia, suus solum profundum variat
January 31, 2011 at 4:10 am
Viewing 15 posts - 136 through 150 (of 597 total)