Forum Replies Created

Viewing 15 posts - 526 through 540 (of 596 total)

  • RE: Recursive query loops

    SQL Noob (1/9/2008)


    why not a multi-step approach

    grab the data out of AD and display the first level of group membership. then run several queries to display the second and third...

  • RE: The Backup Myth

    I think what's coming through loud and clear here is that there are plenty of us who've been there before, so have a good idea of the gotchas and of...

  • RE: The Backup Myth

    Charles Kincaid (1/9/2008)


    We recently had a problem at a prominent client. Many (near) duplicate records were deleted from a critical table. The client IT manager could not use...

  • RE: Recursive query loops

    Just an update.

    Unfortunately, the logic for spotting a group membership loop has a minor flaw. What I've found in practice is that there are a couple of instances in our...

  • RE: The Backup Myth

    And here, more than anywhere else, is where I believe DBAs really earn their money. There's no substitute for experience, and very specific experience at that. It's all very well...

  • RE: Losing Your Job

    jaholbrook (1/8/2008)


    We have become an oversensitive bunch of whiners!

    Seems like everyday you hear or read about someone losing thier job or being publicly chastised for saying or doing something that...

  • RE: Losing Your Job

    Oscar Mannbro (1/8/2008)


    majorbloodnock (1/8/2008)


    Actually, I think we have the answer in place already.

    No. We have one (or actually severel - one per country) definition of what is legally right or...

  • RE: Losing Your Job

    Oscar Mannbro (1/8/2008)


    majorbloodnock (1/8/2008)


    My take on this is relatively simple. IMHO, any person's private life is nothing to do with the company they work for, unless the person's actions in...

  • RE: Losing Your Job

    My take on this is relatively simple. IMHO, any person's private life is nothing to do with the company they work for, unless the person's actions in their private life...

  • RE: Import data from email attachments

    Well, I'm not a programmer first and foremost, so I can't give you a definitive answer, but I can see no reason why this isn't possible. However, you might also...

  • RE: t-test in SQL

    No problem. In that case, I think your only option is going to be to write your own stored procedure. I've had a look at the t-test equation (at http://en.wikipedia.org/wiki/Student's_t-test),...

  • RE: Recursive query loops

    OK, I think I understand it now. In your While loop, you're basically wandering up the hierarchy, writing each parent/child combination to the Hierarchy table, checking first to see if...

  • RE: Recursive query loops

    Hi, Jeff

    That's quite a bit for me to read through and get my head round, so I probably won't post an update for a little while. I did want to...

  • RE: t-test in SQL

    OK, I understand.

    It almost sounds as if you've got the tail wagging the dog a bit here. It just seems a little surprising you're being asked to use an application...

  • RE: t-test in SQL

    Nothing native as far as I know (unless you want to programme something yourself....)

    My guess would be that Microsoft would expect you to use Excel to perform the t-test based...

Viewing 15 posts - 526 through 540 (of 596 total)