Forum Replies Created

Viewing 15 posts - 136 through 150 (of 596 total)

  • RE: The Business - Part 2

    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...

  • RE: Automatically Generate Stored Procedures

    tpepin (2/10/2011)


    ...The second problem, is if you have a calculated column in your table, it will still be in the insert statement. I don't see a column in the...

  • RE: Automatically Generate Stored Procedures

    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...

  • RE: SQL DISTINCT on Multiple Columns

    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...

  • RE: SQL DISTINCT on Multiple Columns

    Koen (da-zero) (2/8/2011)


    Although the article was well-written and a good introduction to DISTINCT, I didn't give it many stars.

    Why? I found that the article didn't introduce us anything that can't...

  • RE: Toys V. Tools

    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...

  • RE: Toys V. Tools

    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...

  • RE: Toys V. Tools

    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...

  • RE: Common table expressions and circular references

    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...

  • RE: Common table expressions and circular references

    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...

  • RE: Common table expressions and circular references

    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...

  • RE: Common table expressions and circular references

    andy.roberts (1/31/2011)

    Something I can't get my head round - can anyone explain ...

    &nbsp &nbsp The result of running the first CTE before the circular relationship was added had extra rows...

  • RE: Common table expressions and circular references

    Perhaps more pertinent in criticising AD is its accessibility. ADSI and LDAP are technically effective, but hardly user-friendly.

  • RE: Common table expressions and circular references

    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...

  • RE: Common table expressions and circular references

    Peter.Frissen (1/31/2011)


    Hi, Cool stuff this CTE, but I have a question about the example.

    Suppose I want to return not only the leaf-to-parent relation, but also any subparent-to-parent? For example, b...

Viewing 15 posts - 136 through 150 (of 596 total)